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
|
| Список | 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 по дате отправления: