Re: Inserting a new column in between. - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Inserting a new column in between.
Date
Msg-id 45E117C6.1090000@commandprompt.com
Whole thread Raw
In response to Inserting a new column in between.  (RPK <rohitprakash123@indiatimes.com>)
Responses Re: Inserting a new column in between.  (RPK <rohitprakash123@indiatimes.com>)
List pgsql-general
RPK wrote:
> I want to know whether I can insert a new column in between in an existing
> table. My table has 10 fields and I want to insert a field after third
> field.

Not without recreating the table.

Sincerely,

Joshua D. Drake

--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-general by date:

Previous
From: RPK
Date:
Subject: Re: problem installing NPGSQL and pgOLEDB with .NET
Next
From: Michael Fuhr
Date:
Subject: Re: some tables unicode, some ascii?