Received: from pacific.usa.dp.ua (onyx.extrasy.net [195.248.166.227]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9PK6NP45844 for ; Thu, 25 Oct 2001 16:06:31 -0400 (EDT) (envelope-from green@pacific.usa.dp.ua) Received: (from green@localhost) by pacific.usa.dp.ua (8.9.3/8.9.3) id XAA82055 for pgsql-sql@postgresql.org; Thu, 25 Oct 2001 23:09:32 +0300 (EEST) (envelope-from green) Date: Thu, 25 Oct 2001 23:09:32 +0300 From: Alexey Prohorenko To: pgsql-sql@postgresql.org Subject: autoincrement Message-ID: <20011025230932.A82025@usa.dp.ua> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0.1i X-Archive-Number: 200110/360 X-Sequence-Number: 5313 How can I reproduce in PostgreSQL type structure from MySQL: INT NOT NULL PRIMARY KEY AUTO_INCREMENT ? To be more exact -- in two words: "how can I create autoincrement field?" Thanks a lot. -- green [http://www.extrasy.net]