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 : kg@kgb.une.edu.au : 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 jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461