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 : : +---------------------------------------+-----------------+
