| From: | "Richard Rowell" <the_pitman(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Auto increment |
| Date: | 2000-09-04 01:24:16 |
| Message-ID: | 39b2e986$1_1@news.shreve.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
In article <vnxr5(dot)4053$nq(dot)48129(at)twister(dot)sunsite(dot)auc(dot)dk>, "Mads Jensen"
<astrup_jensen(at)hotmail(dot)com> wrote:
> Hi
>
> I'm a newbiw with pgsql:
>
> 1: Haven't been able to find the officiel manual to pgsql. What's the
> complete URL?
Hmm, I don't know, I use the book which you can find with all the rest of the docs at:
http://www.postgresql.org/docs/index.html
> 2: How can I make an auto increment with PostGreSQL? is it "inherit"?
One of two ways. Either make the data type "serial" or you can create a sequence and
set the default value of the field to curval(sequence).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Tille | 2000-09-04 05:18:00 | Order by in stored functions |
| Previous Message | John McKown | 2000-09-03 18:07:32 | Re: Week of the Year? |