dumping data to version control using pg_dump? - Mailing list pgsql-general

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