How to clone a table to an empty one

Поиск
Список
Период
Сортировка
От Ramiro Alba
Тема How to clone a table to an empty one
Дата
Msg-id 3A8E90E7.4BFF6C1@labtie.mmt.upc.es
обсуждение исходный текст
Ответы Re: How to clone a table to an empty one  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello everyone:

I would need to create an exact reproduction of a certain table
(excluding data) converving primary key attributes and so on.  I tried
with:
CREATE TABLE AS ...
I also tried :

SELECT *
INTO TABLE ....

In both cases, it does not maintain the primary key atribute that I need
in order to edit the cloned table with StarBase using the unixODBC
driver. The table reads ok, but it is read only due to the fact that
I mention.
Anyone knows the solution?

Regards

--
Ramiro Alba
Laboratori de Termotecnia i Energetica

Departament de Maquines i Motors Termics
ETS d'Enginyers Industrials de Terrassa

C/Colom 11

Tf: 34 - 93 739 86 46
Fax: 34 - 93 739 81 01

e-mail: ramiro@labtie.mmt.upc.es





В списке pgsql-sql по дате отправления:

Предыдущее
От: Jie Liang
Дата:
Сообщение: Re: PL/PgSQL FOR syntax
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to clone a table to an empty one