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

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

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]&g

[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!