From: Michael Glaesemann <grzm@seespotcode.net>
To: Ronald Rojas <ronald.rojas@gmail.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Cc: pgsql-novice@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [NOVICE] alter table table add column
Date: Mon, 30 Jul 2007 23:32:53 -0500
Message-ID: <7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net> (raw)
In-Reply-To: <1185855587.28634.6.camel@localhost>
References: <1185855587.28634.6.camel@localhost>
[Please don't post the same question to many lists. Choose one. If
you're unsure if it's the correct list for your question, ask if
there's a more appropriate one. This question is find for -novice or -
general. Thanks.]
On Jul 30, 2007, at 23:19 , Ronald Rojas wrote:
> And, I want to add the field name age with type integer after
> lastname OR before the address field. How to I do that?
Can't without dumping the database, altering the schema in the dump,
and reloading. But why does it matter? Just call the columns in the
order you want.
Michael Glaesemann
grzm seespotcode net
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: grzm@seespotcode.net, ronald.rojas@gmail.com, pgsql-general@postgresql.org, pgsql-novice@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: [NOVICE] alter table table add column
In-Reply-To: <7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net>
* 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