Is there a good way to individually list the DDL for all individual data
base objects?
Running a data base dump like:
pg_dump mydatabase mydatabase-database.sql
produces one big file with all the DDL and DML to restore the data base,
which is very convenient for most cases.
Using that I
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual data base
objects?
snip
grep -v '^;' listfile | while read a b c n
do
a=${a/;}
echo $a f
pg_restore -L f -f outputdir/$a
Berend Tober wrote:
Is there a good way to individually list the DDL for all individual data
base objects?
These threads might interest you:
http://www.postgresql.org/message-id/AANLkTikLHA2x6U=q-t0j0ys78txhfmdtyxjfsrsrc...@mail.gmail.com
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual data base
objects?
snip
Were you aware that pg_restore can restore to STDOUT, and output DDL for only a
single named
You should probably look at the pg_extractor utility.
https://github.com/omniti-labs/pg_extractor
With it, you can dump individual or selected objects to separate
directories.
On Mon, Nov 24, 2014 at 11:00 AM, Alvaro Herrera alvhe...@2ndquadrant.com
wrote:
Berend Tober wrote:
Is there a
On 11/24/2014 08:12 AM, Berend Tober wrote:
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
snip
Were you aware that pg_restore can restore to STDOUT,
Adrian Klaver wrote:
On 11/24/2014 08:12 AM, Berend Tober wrote:
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober bto...@broadstripe.net a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
snip
Were you aware that pg_restore
Melvin Davidson wrote:
You should probably look at the pg_extractor utility.
https://github.com/omniti-labs/pg_extractor
With it, you can dump individual or selected objects to separate
directories.
That looks like what I'm looking for. (Note: I did Google searching, but
apparently did not