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

From Jim C. Nasby
Subject Re: dumping data to version control using pg_dump?
Date
Msg-id 20051128223550.GF78939@pervasive.com
Whole thread Raw
In response to dumping data to version control using pg_dump?  (Klint Gore <kg@kgb.une.edu.au>)
List pgsql-general
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@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             :                 :
> +---------------------------------------+-----------------+
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: "invalid page header in block 597621 of relation..."error
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Set a blank password for a db user