Change type of column

From: Volker Paul <vpaul(at)dohle(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Change type of column
Date: 2000-07-11 07:31:49
Message-ID: 396ACD65.5E91F1E5@dohle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

how can I change the type of a column, e.g. from varchar() to text?
Or is it possible to drop (i.e. delete) a column without
creating a new table from the old one but without that column,
dropping the old table and renaming the old to the new?

Thanks,

Volker Paul

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Volker Paul 2000-07-11 07:38:50 Re: Supported Encoding
Previous Message Paul McGarry 2000-07-11 07:28:33 Checking for existence of table