Re: dumping data to version control using pg_dump?

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(at)kgb(dot)une(dot)edu(dot)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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461