From: Ronald Rojas <ronald.rojas@gmail.com>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
To: pgsql-novice@postgresql.org
To: pgsql-admin@postgresql.org
Subject: alter table table add column
Date: Tue, 31 Jul 2007 12:19:47 +0800
Message-ID: <1185855587.28634.6.camel@localhost> (raw)
Hi,
Anybody knows how to add column with reference to BEFORE or AFTER any
given column? Let say here's my table structure:
Column | Type | Modifiers
----------+-------------------+-----------
surname | character varying |
lastname | character varying |
address | character varying |
And, I want to add the field name age with type integer after lastname
OR before the address field. How to I do that?
I would really appreciate your response.
Thanks in advance.
==================================================================================================
Ronald Rojas
Systems Administrator
Linux Registered User #427229
==================================================================================================
Arnold's Laws of Documentation:
(1) If it should exist, it doesn't.
(2) If it does exist, it's out of date.
(3) Only documentation for useless programs transcends the
first two laws.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ronald.rojas@gmail.com, pgsql-general@postgresql.org, pgsql-novice@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: alter table table add column
In-Reply-To: <1185855587.28634.6.camel@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox