Re: sequences in schemas

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Joe Maldonado" <jmaldonado(at)webehosting(dot)biz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sequences in schemas
Date: 2004-09-01 06:44:40
Message-ID: opsdmycqn3cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You forgot the ";"

CREATE SCHEMA joe;
CREATE SEQUENCE joe.joe_seq start 1;
CREATE TABLE joe.joe_table (int id, varchar name);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-09-01 07:03:51 Re: Types and SRF's
Previous Message Gaetano Mendola 2004-09-01 06:03:08 Re: Performance on 7.4 vs 7.2?