Re: [GENERAL] dump the database data

2005-07-08 Thread Michael Fuhr
[Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Fri, Jul 08, 2005 at 09:59:35AM -0700, Tony Smith wrote: > no, I did not see it. The insert is INSERT into user > values(5, "George", 1); My dump command is > > pg_dump -d databaseName > > Th

Re: [GENERAL] dump the database data

2005-07-08 Thread Michael Fuhr
On Fri, Jul 08, 2005 at 09:03:47AM -0700, Tony Smith wrote: > >pg_dump -d What's the complete command? > In my dump file I found the insert statements > something like: > > INSERT into user values(5, "George", 1); > INSERT into user values(6, "Richard", 3); > INSERT into use

[GENERAL] dump the database data

2005-07-08 Thread Tony Smith
I have tables create by: create table address( id serial PRIMARY KEY, ...); create table user( id serial PRIMARY KEY, name text not NULL, addressId integer REFERENCES address(id) NOT NULL, UNIQUE(name) ); ... I have used the database for sometime and now I would like to