Alter Column Position

From: "Derrick Betts" <Derrick(at)grifflink(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Alter Column Position
Date: 2003-12-09 22:34:36
Message-ID: 009701c3bea4$a09f1500$0100a8c0@BigOne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera Munoz 2003-12-09 22:34:43 Re: add column sillyness
Previous Message Eric Soroos 2003-12-09 22:29:31 Re: add column sillyness

Browse pgsql-novice by date

  From Date Subject
Next Message Godshall Michael 2003-12-09 22:52:16 Re: Alter Column Position
Previous Message Amy Young 2003-12-09 20:07:11 PostgreSQL Training