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

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: 2007-07-31 04:32:53
Message-ID: 7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novicepgsql-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



In response to

Responses

pgsql-novice by date

Next:From: Ronald RojasDate: 2007-07-31 05:23:11
Subject: Re: [NOVICE] alter table table add column
Previous:From: Ronald RojasDate: 2007-07-31 04:19:47
Subject: alter table table add column

pgsql-general by date

Next:From: Tom LaneDate: 2007-07-31 04:51:46
Subject: Re: How do I create a database if I can't connect to it?
Previous:From: Ronald RojasDate: 2007-07-31 04:19:47
Subject: alter table table add column

pgsql-admin by date

Next:From: Ronald RojasDate: 2007-07-31 05:23:11
Subject: Re: [NOVICE] alter table table add column
Previous:From: Ronald RojasDate: 2007-07-31 04:19:47
Subject: alter table table add column

pgsql-sql by date

Next:From: Ronald RojasDate: 2007-07-31 05:23:11
Subject: Re: [NOVICE] alter table table add column
Previous:From: Ronald RojasDate: 2007-07-31 04:19:47
Subject: alter table table add column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group