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