"Net Virtual Mailing Lists" <mailinglists@net-virtual.com> writes:
> CREATE TABLE testschema.industries (
> industry_id integer DEFAULT nextval('"testschema.industries_industry_id_seq"'::text) NOT NULL,
> pg_dump created it with the double quotes, I have been modifying the dump
> to make it so appropriate things get created inside the schema, so I
> added in the testschema. part of it in this example.
Ah-hah. You put the testschema. part in the wrong place then. Correct
is
nextval('"testschema"."industries_industry_id_seq"'::text)
Or you could leave out the double quotes.
regards, tom lane