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;
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to