Re: SELECT to an external file

psql -c "select * from table" dbname >filename.txt



Mário Gamito wrote:

> Hi,
>
> How can i draw the results of a SELECT in to a file in the filesystem ?
>
> Warm Regards,
> Mário Gamito
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>