Re: autoincrement question
От
Sean Davis
Тема
Re: autoincrement question
Дата
Msg-id
264855a00801071312o27fc6cc8h4d5ddeca6b6acb7@mail.gmail.com
Ответ на
autoincrement question (Jack Albright)
Список
Дерево обсуждения
autoincrement question Jack Albright <jack@mobiusnm.com>
Re: autoincrement question "Sean Davis" <sdavis2@mail.nih.gov>
Re: autoincrement question Richard Broersma Jr <rabroersma@yahoo.com>
Re: autoincrement question "Greg Cocks" <gcocks@stoller.com>
On Jan 7, 2008 3:57 PM, Jack Albright <jack@mobiusnm.com> wrote:
A column of type "serial" will be a simple integer column that gets its values from a sequence, which will be automatically created. In other words:
create table junktable (
pk1 serial primary key
);
will get you what you want. Check out the docs for the "serial" column type.
Sean
I'm new to the list and new to postgreSQL.
I usually work in mySQL.
I'm using NaviCat to manipulate my postgreSQL db.
QUESTION:
What is the best way for a novice like me to make my primary key ID
column auto-increment? It is a basic integer column.
Also, do I need to set a default value for my primary keys?
In MySQL (using phpMyAdmin) it's a simple matter of checking a
checkbox. What is the recommended way to do this in postgres?
A column of type "serial" will be a simple integer column that gets its values from a sequence, which will be automatically created. In other words:
create table junktable (
pk1 serial primary key
);
will get you what you want. Check out the docs for the "serial" column type.
Sean
В списке pgsql-novice по дате отправления
