Alter Column Position

Поиск
Список
Период
Сортировка
Искать
От
Derrick Betts
Тема
Alter Column Position
Дата
Msg-id
009701c3bea4$a09f1500$0100a8c0@BigOne
Список
Дерево обсуждения
Re: PostgreSQL Training "Amy Young" <Amy_Young@hilton.com>
Re: PostgreSQL Training Jeff Eckermann <jeff_eckermann@yahoo.com>
Re: PostgreSQL Training wim <wdh@belbone.be>
Re: PostgreSQL Training Sai Hertz And Control Systems <sank89@sancharnet.in>
I have a table with 10,000 rows.  We have an application that parses a *.csv
file and uploads the data to the database table.  The csv parser takes the
column numbers form the csv file and matches the column numbers to the field
positions in the DB table.

Now, I have to change the position of a column in the DB to match the csv
parser.  I have a column in position 28 that I need to move to position 7.

Anyone know how to do that?

Thanks,
Derrick

В списке pgsql-novice по дате отправления
От: Amy Young
Дата:
Сообщение: PostgreSQL Training
От: Godshall Michael
Дата:
Сообщение: Re: Alter Column Position
FAQ