Search Postgresql Archives

Re: table dump function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 03/07/2013 08:42 AM, Little, Douglas wrote:
Thanks for the suggestion Adrian,

Unfortunately,  my process is executing from psql,  so to start pg_dump from within psql is a bit challenging.
We have 1 instance where we start an OS process from a function, but it's new territory for us.

Yeah, my suggestion was offered in the spirit of not reinventing the wheel:) When you say you are running from inside psql, do you mean interactively or from script? As Rob mentioned from psql you can get to the shell by doing \!.


My function is dumping everything but the ACL grant list.   I currently have a function that will  build and execute the grants from the acl list,
so it's just a simple exercise to get it to dump the statements.

I was just  hoping that there were standard functions for doing this.

Not that I know of. If you feel adventurous you could look at dumpTableSchema in pg_dump.c in the source to see how pg_dump does it.

Thanks
doug



--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux