Closest you'll come is using copy...
psql -c "create temp table ...; copy from temp_table to file"
There has been some discussion about allowing COPY to work from either a
view or an arbitrary SELECT statement; check the -hackers archives.
On Thu, Nov 24, 2005 at 06:21:30PM +1100, Klint Gore wrote:
> Is there any way to get pg_dump to run a statement before dumping?
>
> I'd like to do something like
>
> pg_dump -a -c "create temp table params as select * from params where
> key=blah;" -d dev_db -t params -f /svn/db/params.blah
> svn commit /svn/db/params.blah
>
> I'd rather avoid doing
> psql -c "create table params_svn as select * from params where key = blah;"
> pg_dump .
> psql -c "drop table params_svn"
> replace tmptablename realtablename
> svn commit ...
>
> klint.
>
> +---+-+
> : Klint Gore: "Non rhyming:
> : EMail : [EMAIL PROTECTED] : slang - the:
> : Snail : A.B.R.I.: possibilities :
> : Mail University of New England : are useless" :
> : Armidale NSW 2351 Australia : L.J.J. :
> : Fax : +61 2 6772 5376 : :
> +---+-+
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match