Re: Export to file

On Tue, 2003-09-09 at 09:15, Marvin wrote:
>
> There is a way to export the result
> of a query into an external DBF or TXT table?
>

I often do something like this:
$ psql -At -c 'select ... where ...'

This is so handy, that I have a (bash) shell alias for it:
$ alias csbq='psql -UPUBLIC -dcsb -At -c'
then
$ csbq 'select ...'

-Reece

--
Reece Hart, Ph.D. rkh(at)gene(dot)com, http://www.gene.com/
Genentech, Inc. 650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93 http://www.in-machina.com/~reece/
South San Francisco, CA 94080-4990 reece(at)in-machina(dot)com, GPG: 0x25EC91A0