am Thu, dem 15.03.2007, um 14:35:41 +0100 mailte Shavonne Marietta Wijesinghe folgendes: > When i alter a table and add a new column it always adds it to the end of the > table. Is there any way to tell it to add the new column at the 5th position > or > to add the new column after a surtain column.
No, but you can (and should) define the column-order in the select-statement. Other solutions: - define a VIEW - recreate the table Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
