Re: Sending errors from psql to error file

On Thu, 2004-08-12 at 11:09, Oliver Elphick wrote:
> On Thu, 2004-08-12 at 16:01, Devin Whalen wrote:
> > > zcat cli_postDataInserts.sql.gz |
> > >    psql -d cli_post -U system --echo-queries -f - >trace.file 2>&1
> > 
> > Just a few questions about your command.  I tried it with one sql
> > statement that I know doesn't work and the error went into the right
> > file.  However, I would like to know WHY it works...hope you don't mind
> > shedding some light on it :).  Specifically, the - >trace.file 2>&1
> > part.  I know...well actually think, that the > is redirecting the ouput to the trace.file.  But what the hell is
2>&1doing??
 
> > Also, the - ...it kinda just looks like a stray dash to me....although I know it must be doing something ;).
> > Will this put all output?  Or just the errors.
> 
> ">" redirects standard output
> "2>" redirects standard error
> 
> Your command did not redirect standard error, so the errors didn't get
> to grep
> 
> The syntax for -f is "-f filename"; the filename "-" means standard
> input.  (Check the man page for psql!)
> 
> 
> Oliver

Thanks for you explanations.  They are a big help.  Now that I
understand it better I can modify it to suit my needs.  I really only
want the errors because if I keep track of all the inserts then the file
will be too big.  So I just have to use 2>, or rather 2>> so I can
append to the file.

The syntax for -f is "-f filename"; the filename "-" means standard
> input.  (Check the man page for psql!)

I swear I read it like 15 times and I guess I just scanned over that part every time!! :)

Later

-- 
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982