The output of pg_dump is pretty clean for this purpose already. just thought I'd ask beforehand.
On 10/29/05, Tom Lane <[EMAIL PROTECTED]> wrote:
J French <[EMAIL PROTECTED]> writes:> I did read the page. Been there done that, ran the script. My question was
> if there was a ca
I did read the page. Been there done that, ran the script. My question was if there was a canned script out there that I didn't have to clean up on the fly. This will be an cron job for a convoluted development process. Thanks though.
On 10/29/05, Douglas McNaught <[EMAIL PROTECTED]&g
I need to capture the schema on a postgres database and recreate it on another ansi compliant platform. Is it possible to generate a file (perhaps from pg_dump?) as a sequence of ansi compliant SQL commands which can be used to recreate the structure?
Thanks in advance!