Thank you very much. I will try your suggestions. I'm new to PostgreSQL
and I'm very happy with the quick responses I'm getting from the email
subscription. It's a great help. When I get better I will return the
favors to others in need.
At 12:09 AM 10/4/01 +0000, Lee Harr wrote:
> > I use \o [file] to get output to a file but it only records the
> > command. For example:
> >
> > \o vac.out
> > vacuum verbose analyze;
> >
> > I end up with one row "VACUUM" in vac.out. I want the entire output
> that I
> > see on the screen to go to a file. How is this done?
> >
>
>
>I am not sure how to do this entirely within psql, but you can always
>use the vacuumdb command or the -c flag to psql...
>
>
>vacuumdb --verbose --analyze -d databasename >& output.txt
>psql -c 'vacuum verbose analyze' databasename >& output.txt
>
>
>Note that you must redirect both stdout and stderr to your file
>in order to see everything. That seems to be why \o is not catching
>the output that you want.
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster