From 56d982b7d42c34a7da8ba50a3a51396d8b733aaf Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 17 Jan 2005 03:02:56 +0000 Subject: Mention ALTER COLUMN TYPE in FAQ. --- doc/src/FAQ/FAQ.html | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index b69e3c66ccc..3117b90e6bd 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sun Jan 16 21:40:18 EST 2005

+

Last updated: Sun Jan 16 22:01:06 EST 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -854,8 +854,8 @@

4.4) How do you remove a column from a table, or change its data type?

-

DROP COLUMN functionality was added in release 7.3 with - ALTER TABLE DROP COLUMN. In earlier versions, +

DROP COLUMN functionality was added in release 7.3 + with ALTER TABLE DROP COLUMN. In earlier versions, you can do this:

     BEGIN;
@@ -868,7 +868,10 @@
     COMMIT;
-

To change the data type of a column, do this:

+

Changing the data type of a column can be done easily in 8.0 + and later with ALTER TABLE ALTER COLUMN TYPE. + +

In earlier releases, do this:

     BEGIN;
     ALTER TABLE tab ADD COLUMN new_col new_data_type;
-- 
cgit v1.2.3