Re: Export to file - Mailing list pgsql-admin

From Reece Hart
Subject Re: Export to file
Date
Msg-id 1063207051.2448.80.camel@tallac
Whole thread Raw
In response to Export to file  ("Marvin" <magosoft@gmx.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Export to file
Next
From: Jodi Kanter
Date:
Subject: extended view of sql