Re: ps_dump -a

On Tue, Oct 29, 2002 at 10:24:48AM -0500, Johnson, Shaunn wrote:
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2:
>
> I'm trying to do a "pg_dump -a -t t_table -d testdb > out.txt"
> and I'm still getting header information. How can I do
> a dump of data to a text file and not get information like
> the comments, Date for TOC Entry, Name, etc ... I just
> want the raw data. I've tried to pipe it through using
> tail, but I don't know if I'm missing the beginning of the
> file.

What about

pg_dump -a -t t_table -d testdb | grep -v "^--" > out.txt

? The grep will get rid of any line that begins with "-", which will
be a comment line.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110