On Sat, 2022-01-22 at 09:08 -0800, Wells Oliver wrote: > I need only drop the column and VACUUM FULL the table, and not the entire DB, right? Not that VACUUM (FULL) will *not* physically get rid of a dropped column, as it just copies the complete rows to a new table. You would need something like: CREATE TABLE newtab (LIKE oldtab); INSERT INTO newtab SELECT * FROM oldtab; Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
