Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Inserting a new column in between.


  • From: "Joshua D. 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: Sat, 24 Feb 2007 20:59:50 -0800
  • Message-id: <45E117C6(dot)1090000(at)commandprompt(dot)com>

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/




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group