Skip site navigation (1)
Skip section navigation (2)
[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.]
Peripheral Links
Header And Logo
|
Site Navigation
Re: [NOVICE] alter table table add column
- From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- To: Ronald Rojas <ronald(dot)rojas(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [NOVICE] alter table table add column
- Date: Mon, 30 Jul 2007 23:32:53 -0500
[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
- Follow-Ups:
- Re: [NOVICE] alter table table add column
- From: Ronald Rojas
- Re: [NOVICE] alter table table add column
- References:
- alter table table add column
- From: Ronald Rojas
- alter table table add column
- Prev by Date: alter table table add column
- Next by Date: Re: How do I create a database if I can't connect to it?
- Previous by thread: alter table table add column
- Next by thread: Re: [NOVICE] alter table table add column
- Indexes: