Chris Browne <[EMAIL PROTECTED]> writes:
> I have a table that has a candidate primary key (e.g. - unique, not
> null) that I wish to actually assert _is_ a primary key.
> Is there a way to do that without too much (mwahahhaha! fiddling with
> pg_class!!!) trickery?
Why don't you just ALTER TABLE
> Is there a way to do that without too much (mwahahhaha! fiddling with
> pg_class!!!) trickery?
esp=# alter table test add primary key(id);
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
"test_pkey" for table "test"
ALTER TABLE
---(end of broadcast)
