select results...

Hi

I am writing a bash script at the moment and as a part of it I need to extract all the info from a db column to a text file.



But the problem is that the name.txt file comes out as such...



Is there any way to set the select not to print these or should I just write something to parse out the heading lines and the space before the name?

Cheers....

I belive you can customize your psql not to print them.

I think there is a psql option also, but you could use head/tail to strip off those two lines, right? I have to write bash stuff too sometimes, but how come you are not using perl or python?

more specifically, now you can do it with a command-line option:

-t
--tuples-only

Turn off printing of column names and result row count footers, etc. It is completely equivalent to the \t meta-command.

so psql -t -c 'SELECT foo FROM bar;' >> file.txt will not include the headers