Re: Create Table Scripts - Mailing list pgsql-novice

From Chuck Kimber
Subject Re: Create Table Scripts
Date
Msg-id 3A573DEA.AD2F5294@ext.usu.edu
Whole thread Raw
In response to Re: Create Table Scripts  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-novice
> > pg_dump -s <database>
> >
> > will dump out scripts to build your database.  If you eliminate the -s, it
> > will also dump the data as insert statements.
>
> I'm sorry, that's not quite correct -- the -d option will dump your data
> as insert statements, otherwise your data gets dumped directly and can be
> copied back into the database as a COPY form stdin.
>
> -- Brett

YOU DA MAN!!

pg_dump -s was perfect!

If I weren't a married man... I'd kiss you...

What the heck.

*smoooooch*

-Chuck


pgsql-novice by date:

Previous
From: "rob"
Date:
Subject: Re: Determining parent.
Next
From: Mike Friesen
Date:
Subject: Join question