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@xxxxxxxxxxxxxx : 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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
