On 3/29/23 21:06, David G. Johnston wrote:
It would be really helpful to be able to reposition columns in tables. That
way, one could:
add the new TIMESTAMP column,
populate it using to_timestamp(),
drop the text column,
reposition the TIMESTAMP column to where it "should" be.
If that would give you what you need then just define the column as text initially, load the data, then do an ALTER COLUMN ... ALTER TYPE to change the column type to timestamptz in place, with the conversion done via USING.
David J.
Something like this?
ALTER TABLE foo
ALTER COLUMN update_ts TIMESTAMP WITHOUT TIME ZONE
USING to_timestamp(update_ts, 'YYYYMMDDHH24miSSMS');
That would definitely minimize the possibility of errors.
--
Born in Arizona, moved to Babylonia.