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@gene.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@in-machina.com, GPG: 0x25EC91A0