Thread: Auto Increment
Is there a way set a primary key to Auto Increment like you can
with MySQL?
Thanks..
postgres@flipper.webdevelop.net wrote: > > Is there a way set a primary key to Auto Increment like you can >with MySQL? CREATE TABLE junk (id SERIAL PRIMARY KEY, ...etc...) The SERIAL data type is an INTEGER coupled with a sequence which is created automatically. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "And they said, Believe on the Lord Jesus Christ, and thou shalt be saved, and thy house." Acts 16:31
On Tue, 26 Dec 2000 postgres@flipper.webdevelop.net wrote:
> Is there a way set a primary key to Auto Increment like you can
> with MySQL?
See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
SERIAL type.
[An aside: this is something definitely that qualifies as a frequently
asked question, as this is like the 4th time in a week this question has
been asked. Would posting a FAQ list on a regular basis to the list be
helpful for things like this, like is done on the Perl newsgroups?]
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Hanson's Treatment of Time:
There are never enough hours in a day, but always too many days
before Saturday.
> On Tue, 26 Dec 2000 postgres@flipper.webdevelop.net wrote: > > > Is there a way set a primary key to Auto Increment like you can > > with MySQL? > > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the > SERIAL type. > > [An aside: this is something definitely that qualifies as a frequently > asked question, as this is like the 4th time in a week this question has > been asked. Would posting a FAQ list on a regular basis to the list be > helpful for things like this, like is done on the Perl newsgroups?] > I don't think so. Doesn't everyone know the location of the FAQ? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Tue, 26 Dec 2000, Bruce Momjian wrote:
> > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
> > SERIAL type.
> >
> > [An aside: this is something definitely that qualifies as a frequently
> > asked question, as this is like the 4th time in a week this question has
> > been asked. Would posting a FAQ list on a regular basis to the list be
> > helpful for things like this, like is done on the Perl newsgroups?]
> >
>
> I don't think so. Doesn't everyone know the location of the FAQ?
Perhaps not -- this is what I am wondering. Is it sent to subscribers as
part of a welcome message? At any rate, this particular question I think
has now qualified for the FAQ, at the very least! Or maybe even a section
in the FAQ for people coming over from MySQL...
-- Brett
PS. Got your book, Bruce. Nice job!
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
"The pyramid is opening!"
"Which one?"
"The one with the ever-widening hole in it!"
-- The Firesign Theatre
> On Tue, 26 Dec 2000, Bruce Momjian wrote: > > > > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the > > > SERIAL type. > > > > > > [An aside: this is something definitely that qualifies as a frequently > > > asked question, as this is like the 4th time in a week this question has > > > been asked. Would posting a FAQ list on a regular basis to the list be > > > helpful for things like this, like is done on the Perl newsgroups?] > > > > > > > I don't think so. Doesn't everyone know the location of the FAQ? > > Perhaps not -- this is what I am wondering. Is it sent to subscribers as > part of a welcome message? At any rate, this particular question I think > has now qualified for the FAQ, at the very least! Or maybe even a section > in the FAQ for people coming over from MySQL... It is already in the FAQ, right? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Wed, 27 Dec 2000, Bruce Momjian wrote: > > Perhaps not -- this is what I am wondering. Is it sent to subscribers as > > part of a welcome message? At any rate, this particular question I think > > has now qualified for the FAQ, at the very least! Or maybe even a section > > in the FAQ for people coming over from MySQL... > > It is already in the FAQ, right? Doh! OK, now that my foot is out of my mouth... perhaps a gentle reminder to some of the newer folks that a lot of questions asked are answered in the FAQ already, and if you don't know where the FAQ is, go to http://www.postgresql.org/docs/faq-english.html (there are also FAQs in German, Japanese and Korean). And don't mind me... been a long evening of coding... -- Brett http://www.chapelperilous.net/~bmccoy/ --------------------------------------------------------------------------- An aphorism is never exactly true; it is either a half-truth or one-and-a-half truths. -- Karl Kraus
>> Would posting a FAQ list on a regular basis to the list be
>> helpful for things like this, like is done on the Perl newsgroups?]
> I don't think so. Doesn't everyone know the location of the FAQ?
Undoubtedly not :-( ... but it's unlikely that a routine posting would
help to dispel cluelessness, either. More likely it'd just waste space
in the archives.
At one time Marc was arranging for the list bot to append automatic
tags to all postings. I'd be in favor of an automatic tag that read
something like
list administrivia: majordomo@hub.org
Postgres FAQs: http://...
Suggestions anyone? (Keep in mind that brevity is the soul of wit
here...)
regards, tom lane
> OK, now that my foot is out of my mouth... perhaps a gentle reminder to > some of the newer folks that a lot of questions asked are answered in the > FAQ already, and if you don't know where the FAQ is, go to > http://www.postgresql.org/docs/faq-english.html (there are also FAQs in > German, Japanese and Korean). > > And don't mind me... been a long evening of coding... Here is the text I use for people who e-mail me directly. Seems to do the trick. --------------------------------------------------------------------------- Due to time constraints, I do not directly answer general PostgreSQL questions. For assistance, please join the appropriate mailing list and post your question: http://postgresql.org/users-lounge You can also try the #postgresql IRC channel. See the PostgreSQL FAQ for more information. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Wed, 27 Dec 2000, Tom Lane wrote:
> At one time Marc was arranging for the list bot to append automatic
> tags to all postings. I'd be in favor of an automatic tag that read
> something like
>
> list administrivia: majordomo@hub.org
> Postgres FAQs: http://...
>
> Suggestions anyone? (Keep in mind that brevity is the soul of wit
> here...)
I think that's a good idea... one line in a tag may save many packets of
questions that don't need to be asked on the list if they have already
been answered. :-)
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Premature optimization is the root of all evil.
-- D.E. Knuth
Tom Lane writes: > At one time Marc was arranging for the list bot to append automatic > tags to all postings. I'd be in favor of an automatic tag that read > something like > > list administrivia: majordomo@hub.org > Postgres FAQs: http://... > > Suggestions anyone? (Keep in mind that brevity is the soul of wit > here...) RFC 2369 <http://www.faqs.org/rfcs/rfc2369.html> This essentially says that you add headers like this to every mail: List-Help: <mailto:autoconf-request@gnu.org?subject=help> List-Post: <mailto:autoconf@gnu.org> List-Subscribe: <http://mail.gnu.org/mailman/listinfo/autoconf>, <mailto:autoconf-request@gnu.org?subject=subscribe> List-Id: Discussion list for the autoconf build system <autoconf.gnu.org> List-Unsubscribe: <http://mail.gnu.org/mailman/listinfo/autoconf>, <mailto:autoconf-request@gnu.org?subject=unsubscribe> List-Archive: <http://mail.gnu.org/pipermail/autoconf/> (There's isn't anything for FAQ, but there could be a link on the archive page maybe.) If a mail with these headers shows up in my mail client I get a link "This message contains email list management information." that I can click on and which in turn explains to me what an email list is and then allows me to click on the URLs above. Very nice. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
I had looked everywhere to find the answer to this question. Now that I look at the FAQ again I see it in there. I tryed searching the FAQ for "auto increment" when it turns out to be "auto-increment" on the FAQs page. Being a MySQL user who was dead ended and had no choice but to find a new database with Transactions or something simliar because of MySQL's limitations I had several questions that seemed difficult to find during the switchover. 1. Auto increment - now serial datatype 2. 'SHOW TABLES' in mysql - now '\d' (I got lucky to stumble apon this.) 3. 'DESCRIBE' in mysql - now '\d tablename' (same as above.) As more people realize MySQL's limitations I think there will be more people making the switchover. As a result I'm sure many people find themselves asking the same questions I did. I would recommend these 3 things be easy to find the the FAQ for MySQL familiar users. My 2 cents... On Tue, 26 Dec 2000, Brett W. McCoy wrote: > On Tue, 26 Dec 2000 postgres@flipper.webdevelop.net wrote: > > > Is there a way set a primary key to Auto Increment like you can > > with MySQL? > > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the > SERIAL type. > > [An aside: this is something definitely that qualifies as a frequently > asked question, as this is like the 4th time in a week this question has > been asked. Would posting a FAQ list on a regular basis to the list be > helpful for things like this, like is done on the Perl newsgroups?] > > -- Brett > http://www.chapelperilous.net/~bmccoy/ > --------------------------------------------------------------------------- > Hanson's Treatment of Time: > There are never enough hours in a day, but always too many days > before Saturday. >