PRIMARY KEYS

Поиск
Список
Период
Сортировка
Искать
От
javier garcia - CEBAS
Тема
PRIMARY KEYS
Дата
в 05:49:46
Msg-id
200305200852.h4K8pmI23465@natura.cebas.csic.es
Список
Дерево обсуждения
Re: PRIMARY KEYS Vivek Khera <khera@kcilink.com>
Re: PRIMARY KEYS Martijn van Oosterhout <kleptog@svana.org>
Re: PRIMARY KEYS Erik Price <eprice@ptc.com>
Hi;
I'm pretty new in Postgres.
I've created several tables but I didn't care about PRIMARY KEYS in the 
begining. Now I woul like to add them to the tables.
I've read that PostgreSQL adds an automatic column called OID to each table; 
but when I do a SELECT, the OID column doesn't not appear.
Is this OID column a PRIMARY KEY by default? Can I see it?
How can I see what column is the primary key in a table?
Can I select, at any moment a different Prymary Key?
Can I alter the values of a Prymary Key in a Table?

Thanks and  forgive me for these basic questions.

Best wishes
Javier


 
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Kaarel
Дата:
Сообщение: INSERT/UPDATE/DELETE Views
FAQ