can postgresql alter table modify datatype for existing column

From: Flower Sun <sun_2002_flower(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: can postgresql alter table modify datatype for existing column
Date: 2003-03-18 21:43:51
Message-ID: 20030318214351.30079.qmail@web14604.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi, group,

Question 1: Does any one know whether postgresql has "alter table modify datatype for existing column" syntax available for version 7.3.1?

Question 2: Does any one know the command to display DDL for creating postgresql tables from psql client tool?

Thank you,

Jing

---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-03-18 21:57:12 log_timestamp and SIGHUP?
Previous Message Kurt Overberg 2003-03-18 20:54:43 Re: Big insert/delete memory problems