ALTER TABLE users MODIFY COLUMN…
ALTER TABLE users ALTER COLUMN…
ALTER TABLE users ADD CONSTRAINT…
You have to create a new temporary table with correct schema, copy data into this new table, drop the old table, and then rename the temporary table.
HN'er since 2011 when PG responded and was active.
Other companies: NodeSocket, Commando.io, Elastic Byte.
Living in Nashville, Tennessee. Charlie Munger "there are three ways to go broke... liquor, ladies and leverage."