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