How to re-order fields in table?

#61

EricF wrote:

Quote:

You can do this with SQL Manager. There is a "Lite" version that is a free
download.

Another way, if you seldom do that (*) and you can dump and restore the DB:

pg_dump -d --attribute-inserts

creates a dump with INSERT INTO (col1, col2...)

Then, you manually change the column order in the CREATE TABLE
statements, and restore the db.

(*) no, I dont' believe too much in emergent db design :-)

#62

EricF wrote:

Quote:

You can do this with SQL Manager. There is a "Lite" version that is a free
download.

Another way, if you seldom do that (*) and you can dump and restore the DB:

pg_dump -d --attribute-inserts

creates a dump with INSERT INTO (col1, col2...)

Then, you manually change the column order in the CREATE TABLE
statements, and restore the db.

(*) no, I dont' believe too much in emergent db design :-)

#63

EricF wrote:

Quote:

You can do this with SQL Manager. There is a "Lite" version that is a free
download.

Another way, if you seldom do that (*) and you can dump and restore the DB:

pg_dump -d --attribute-inserts

creates a dump with INSERT INTO (col1, col2...)

Then, you manually change the column order in the CREATE TABLE
statements, and restore the db.

(*) no, I dont' believe too much in emergent db design :-)

#64

EricF wrote:

Quote:

You can do this with SQL Manager. There is a "Lite" version that is a free
download.

Another way, if you seldom do that (*) and you can dump and restore the DB:

pg_dump -d --attribute-inserts

creates a dump with INSERT INTO (col1, col2...)

Then, you manually change the column order in the CREATE TABLE
statements, and restore the db.

(*) no, I dont' believe too much in emergent db design :-)

#65

EricF wrote:

Quote:

You can do this with SQL Manager. There is a "Lite" version that is a free
download.

Another way, if you seldom do that (*) and you can dump and restore the DB:

pg_dump -d --attribute-inserts

creates a dump with INSERT INTO (col1, col2...)

Then, you manually change the column order in the CREATE TABLE
statements, and restore the db.

(*) no, I dont' believe too much in emergent db design :-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to re-order fields in table?

comp.databases.postgresql comp.databases.postgresql

Re: How to re-order fields in table? - 03-28-2008 , 03:34 AM

Re: How to re-order fields in table? - 03-28-2008 , 03:34 AM

Re: How to re-order fields in table? - 03-28-2008 , 03:34 AM

Re: How to re-order fields in table? - 03-28-2008 , 03:34 AM

Re: How to re-order fields in table? - 03-28-2008 , 03:34 AM