Re: [GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread J French
No problems.  I am about to write a python script to cleanup the output of pg_dump.  Before I do I just wanted to verify that there wasn't an already available script which I could feed  directly into another ansi compliant database without modification.  No sense reinventing the wheel.  The output

Re: [GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread Tom Lane
J French <[EMAIL PROTECTED]> writes: > 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. If your schema isn't using any non-

Re: [GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread Douglas McNaught
J French <[EMAIL PROTECTED]> writes: > 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. Yeah, that wo

Re: [GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread J French
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]> wrote: J

Re: [GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread Douglas McNaught
J French <[EMAIL PROTECTED]> writes: > 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?

[GENERAL] Generating an ANSI compliant schema recreation script

2005-10-29 Thread J French
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!