Re: primary key generation

Here is an example:

CREATE SEQUENCE format_id_count;
CREATE TABLE format (
FOREIGN KEY(vehicle_id) REFERENCES vehicle(vehicle_id),

format_id INTEGER PRIMARY KEY
DEFAULT
NEXTVAL('format_id_count
'),
vehicle_id INTEGER,

format_type VARCHAR(11),
description VARCHAR(31),
.......

--- Ned Matson <ned(at)go(dot)com> wrote:
> Does postgres have any built-in methods for auto-generating unique
> integer
> primary keys or is managing this task the responsibility of the user?
>
> Thanks in advance...
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com