Re: Create Table Scripts

From: Chuck Kimber <chuckk(at)ext(dot)usu(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Create Table Scripts
Date: 2001-01-06 15:46:50
Message-ID: 3A573DEA.AD2F5294@ext.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-06 17:04:18 Re: Re: I think I know what I'm doing wrong, but....
Previous Message Eric Nielsen 2001-01-06 14:48:46 Re: I think I know what I'm doing wrong, but....