On 03/07/2013 11:09 AM, Little, Douglas wrote:
Adrian,
Thank you for your comments.
This is part of our deployment framework. DDL files are submitted to the
framework, which eventually run as psql scripts.
Just out of curiosity, if you are creating the DDL, do you not already
have the schem
Adrian Klaver wrote on 07.03.2013 19:18:
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.
I think a function "pg_get_tabledef()" would be very helpful.
We already have a lot of pg_get_XXXdef() functions (pg_get
al Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, March 07, 2013 12:19 PM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general@postgresql.org)
Subject: Re: [GENERAL] table dump function
On 03/07/2013 08:42 AM, Little, Douglas wrote:
> Thanks for the sugg
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
On 03/07/2013 09: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.
My fu
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.
My function is dumping everything but the ACL grant
On 03/07/2013 07:58 AM, Little, Douglas wrote:
I need a pl/pgsql function that will dump a table ddl so I can export
the definition to a file before I drop the object.
the psql \d command won’t work, since it doesn’t dump the table ddl, it
just lists the table’s attributes and indexes.
I’ve g
I need a pl/pgsql function that will dump a table ddl so I can export the
definition to a file before I drop the object.
the psql \d command won't work, since it doesn't dump the table ddl, it just
lists the table's attributes and indexes.
I've got the function mostly working, but need help
