Re: delete column

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Hillensbeck, Preston" <PHillensbeck(at)sfbcic(dot)com>, "'webmaster'" <webmaster(at)harbornet(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: delete column
Date: 2002-04-27 04:48:21
Message-ID: 5.1.0.14.1.20020427124603.0307f090@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oops my mistake! I actually didn't use select into to create the table,
because I didn't want the columns exactly the same as before - was
switching from varchar to text.

:).

Link.

At 11:03 PM 4/26/02 -0400, Bruce Momjian wrote:

>Good. However, why do you do the 'create new table' when the SELECT
>INTO creates the table?
>
>FAQ updated to take advantage of rollback-able DROP TABLE:

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-04-27 06:01:55 Re: delete column
Previous Message Mikail Majorov 2002-04-27 04:25:58 Close access on DB or TABLE.