Skip site navigation (1) Skip section navigation (2)

Inserting preset values into a serial column

From: Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Inserting preset values into a serial column
Date: 2010-07-21 14:53:38
Message-ID: 21E336AE-83EA-47B9-A27C-579A7AD81392@internode.on.net (view raw or flat)
Thread:
Lists: pgsql-novice
PostgreSQL 8.4.4.1

Can someone pls confirm that, provided I am doing it right, I can insert a row into a table where the primary key is serial NOT NULL and a (unique) value is provided in the offered data?  I cannot see an answer to this specific point in the docs.

TIA

Michael Rowan
mike(dot)rowan(at)internode(dot)on(dot)net

11 Kingscote Street
ALBERTON
South Australia 5014

tel 618 8240 3993




Responses

pgsql-novice by date

Next:From: Chris BrowneDate: 2010-07-21 16:44:36
Subject: Re: Inserting preset values into a serial column
Previous:From: listsDate: 2010-07-21 13:41:03
Subject: Has postgres in any configuration been certified against ISO/IEC 15408?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group