File tree Expand file tree Collapse file tree 2 files changed +8
-2
lines changed Expand file tree Collapse file tree 2 files changed +8
-2
lines changed Original file line number Diff line number Diff line change 11
22 Frequently Asked Questions (FAQ) for PostgreSQL
33
4- Last updated: Thu Apr 18 00:44:51 EDT 2002
4+ Last updated: Fri Apr 26 23:03:46 EDT 2002
55
66 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77
637637 4.4) How do you remove a column from a table?
638638
639639 We do not support ALTER TABLE DROP COLUMN, but do this:
640+ BEGIN;
641+ LOCK TABLE old_table;
640642 SELECT ... -- select all columns but the one you want to remove
641643 INTO TABLE new_table
642644 FROM old_table;
643645 DROP TABLE old_table;
644646 ALTER TABLE new_table RENAME TO old_table;
647+ COMMIT;
645648
646649 4.5) What is the maximum size for a row, a table, and a database?
647650
Original file line number Diff line number Diff line change 1414 alink ="#0000ff ">
1515 < H1 > Frequently Asked Questions (FAQ) for PostgreSQL</ H1 >
1616
17- < P > Last updated: Thu Apr 18 00:44:51 EDT 2002</ P >
17+ < P > Last updated: Fri Apr 26 23:03:46 EDT 2002</ P >
1818
1919 < P > Current maintainer: Bruce Momjian (< A href =
2020 "mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR >
@@ -827,11 +827,14 @@ <H4><A name="4.4">4.4</A>) How do you remove a column from a
827827 < P > We do not support < SMALL > ALTER TABLE DROP COLUMN,</ SMALL > but do
828828 this:</ P >
829829< PRE >
830+ BEGIN;
831+ LOCK TABLE old_table;
830832 SELECT ... -- select all columns but the one you want to remove
831833 INTO TABLE new_table
832834 FROM old_table;
833835 DROP TABLE old_table;
834836 ALTER TABLE new_table RENAME TO old_table;
837+ COMMIT;
835838</ PRE >
836839
837840 < H4 > < A name ="4.5 "> 4.5</ A > ) What is the maximum size for a row, a
You can’t perform that action at this time.
0 commit comments