From: Ferindo Middleton Jr <fmiddleton@verizon.net>
To: pgsql-sql@postgresql.org
Subject: changing a column's position in table, how do you do that
Date: Tue, 27 Sep 2005 18:52:11 -0400
Message-ID: <4339CD1B.10404@verizon.net> (raw)
Is there a way to change the position attribute of a column in a table?
I have data that I need to import into various tables in my db on a
consistent basis... I usually us e the COPY ... FROM query but I can't
control the -order- of the fields my client dumps the data so I would
like to be able to change the position the columns in my table to be
able to better align the data to be imported with the format of my
table. I was thinking I could do something like "ALTER TABLE ALTER
COLUMN ... " or something like that to change the columns position in
the table but I can't figure out how.
Ferindo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fmiddleton@verizon.net
Subject: Re: changing a column's position in table, how do you do that
In-Reply-To: <4339CD1B.10404@verizon.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox