If you mean while using psql with the -c switch, add -t.
psql -t dbname username -c "select * from foo" > data_file.txt
If you mean from within the client environment, use \t.
Charley
sdger erger wrote:
> When I retrieve SQL queries through the command line I get outputs like:
>
> *Code:*
> Title
> -------
> value
> (1 row)
>
>
> Is there anything I can do, any option I can choose, to retrieve only the
> value?
>
> *Code*
> value
>