1.15 DD - order of columns

Поиск
Список
Период
Сортировка
От Colin Beckingham
Тема 1.15 DD - order of columns
Дата
Msg-id 4F929ADB.5040700@start.ca
обсуждение исходный текст
Ответы Re: 1.15 DD - order of columns  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
Another issue with creating SQL from the DD is that unpredictably the 
order of columns will change. Say you have authid, authname in your 
original table, your copy might be defined as or authid, authname or 
authname, authid in the copy.

Order of columns is important in Postgresql since it can't easily be 
changed after table is created without delete and add back in a specific 
order.

It appears to be important with respect to import of data from CSV, for 
example, where even if the header defines columns in a specific order, 
the import does not pick that up.

Workaround is of course to open up the csv in a SS, rearrange the cols 
to suit, and export back to CSV, or simply drop and recreate the table 
using the SQL from the original definition if you have that option.
-- 
---
Colin Beckingham
613-454-5369
http://www.it4gh.com


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

Предыдущее
От: Colin Beckingham
Дата:
Сообщение: Re: 1.15 Database Designer and character varying length option
Следующее
От: Colin Beckingham
Дата:
Сообщение: 1.15 DD - serial copied as integer