| 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: | 2007-07-31 04:32:53 |
| Message-ID: | 7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-novice pgsql-sql |
[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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ronald Rojas | 2007-07-31 05:23:11 | Re: [NOVICE] alter table table add column |
| Previous Message | Ronald Rojas | 2007-07-31 04:19:47 | alter table table add column |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-07-31 04:51:46 | Re: How do I create a database if I can't connect to it? |
| Previous Message | Ronald Rojas | 2007-07-31 04:19:47 | alter table table add column |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ronald Rojas | 2007-07-31 05:23:11 | Re: [NOVICE] alter table table add column |
| Previous Message | Ronald Rojas | 2007-07-31 04:19:47 | alter table table add column |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ronald Rojas | 2007-07-31 05:23:11 | Re: [NOVICE] alter table table add column |
| Previous Message | Ronald Rojas | 2007-07-31 04:19:47 | alter table table add column |