Postgres Pro
Downloads
Home   >   mailing lists

Alter Column Position - Mailing list pgsql-novice

From Derrick Betts
Subject Alter Column Position
Date
Msg-id 009701c3bea4$a09f1500$0100a8c0@BigOne
Whole thread Raw
In response to PostgreSQL Training  ("Amy Young" <Amy_Young@hilton.com>)
Responses Re: Alter Column Position
Re: Alter Column Position
List pgsql-novice
Tree view 
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 by date:

Previous
From: "Amy Young"
Date:
Subject: PostgreSQL Training
Next
From: Godshall Michael
Date:
Subject: Re: Alter Column Position