[postgis-users] No Primary Key

[Kevin Neufeld]

P Kishor wrote:
>> create table coal AS SELECT * from geology where group_='GONDWANA';
>>
>> But the resultant table coal is not having a 'primary key'.
>> table geology has gid as primary key.
>>
>> Pl give me a way how I can get a primary key on table coal.
>>

ALTER TABLE coal ADD PRIMARY KEY (gid);
ANALYZE coal;