Re: Primary Keys

Поиск
Список
Период
Сортировка
Искать

Re: Primary Keys

От:
"Thomas F. O'Connell" <tfo@monsterlabs.com>
Дата:
Brian Z wrote:

> How can you create a Primary Key which contains multiple columns on for a
> table.

first of all, i recommend checking out the syntax for the CREATE TABLE 
command. it's available here:

http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/sql-createtable.html

for a quick example, though:

create table foo (
	bar int4,
	baz int4,
	ola int4,
	primary key( bar, baz )
);

this statement will make the columns bar and baz coincidentally the 
primary key for the table foo.

-tfo

FAQ