Re: Inserting a new column in between.

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: RPK <rohitprakash123(at)indiatimes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting a new column in between.
Date: 2007-02-25 04:59:50
Message-ID: 45E117C6.1090000@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-02-25 05:01:17 Re: some tables unicode, some ascii?
Previous Message RPK 2007-02-25 04:56:24 Re: problem installing NPGSQL and pgOLEDB with .NET

Browse pgsql-novice by date

  From Date Subject
Next Message RPK 2007-02-25 07:08:05 Re: Inserting a new column in between.
Previous Message RPK 2007-02-25 04:53:51 Inserting a new column in between.