pg_dump & restore question regarding creating with serial - Mailing list pgsql-novice

From Pam Wampler
Subject pg_dump & restore question regarding creating with serial
Date
Msg-id 2E4528861499D41199D200A0C9B15BC001D5065E@FRISTX
Whole thread Raw
Responses Re: pg_dump & restore question regarding creating with serial
List pgsql-novice
Hi
I am trying to make a copy of one database to another.  I have done the
pg_dump and then psql -f filename into new database-- but when I look at a
table that has been created with (id serial primary key) -- -- on the new
database the id does not start at 1 but the number greater than the last id
of the original table.  How can I make the id start at 1  -- I would have
thought that the initial load into the new database would be an exact
replica of the original database?

When I do \d for the table I see this:

 id           | integer                     | not null default
nextval('"inv_trans_id_seq"'::text)

thanks

Pam Wampler

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: help about service postgres
Next
From: Josh Berkus
Date:
Subject: Re: pg_dump & restore question regarding creating with serial