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
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 a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
Were you aware that pg_restore can restore to STDOUT, and ou
On 11/24/2014 08:12 AM, Berend Tober wrote:
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober a écrit :
Is there a good way to individually list the DDL for all individual
data base objects?
Were you aware that pg_restore can restore to STDOUT, and output DDL
for only a si
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
wrote:
> Berend Tober wrote:
> > Is there a good way to individually
François Beausoleil wrote:
Le 2014-11-24 à 10:14, Berend Tober a écrit :
Is there a good way to individually list the DDL for all individual data base
objects?
Were you aware that pg_restore can restore to STDOUT, and output DDL for only a
single named object from a custom dump file?
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
http://www.postgresql.org/message-id/caaswcxdkroy2uhlo
Le 2014-11-24 à 10:14, Berend Tober a écrit :
> Is there a good way to individually list the DDL for all individual data base
> objects?
>
> grep -v '^;' listfile | while read a b c n
>do
> a=${a/;}
> echo $a > f
> pg_restore -L f -f outputdir/$a dumpfile
>done
>
> T
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
