On Wednesday 30 July 2003 17:21, Guillaume Houssay wrote: > I am looking for the SQL query to add a column in a table and having the > column at specific position in the table (not at the end of the table).
Sorry - you'll need to dump and restore the table. PG only adds columns at the end. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match