dumping data to version control using pg_dump?
От | Klint Gore |
---|---|
Тема | dumping data to version control using pg_dump? |
Дата | |
Msg-id | 438569FA365.AF0EKG@129.180.47.120 обсуждение исходный текст |
Ответы |
Re: dumping data to version control using pg_dump?
|
Список | 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 : : +---------------------------------------+-----------------+
В списке pgsql-general по дате отправления: