Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8542E9FBAF1 for ; Tue, 31 Jul 2007 02:23:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 49119-01-3 for ; Tue, 31 Jul 2007 02:23:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by postgresql.org (Postfix) with ESMTP id 8C37B9FBADE for ; Tue, 31 Jul 2007 02:23:22 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id f1so432481rvb for ; Mon, 30 Jul 2007 22:23:21 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=YGVJ9bk+Grp/r2ZciruNya8uqseQRdus19lW+0nh0s3oyjB4dVy9URfbwipeu+gc5CCTtTnbmN0wR5Qr8bCg2GYd1638skUGpkHiYZFhysY0DJp+DR0TiQVJxxsZItYUjQ2+K9yqi2+lSoUr9K2JzXgWxmwST3+O6FEQj8z8Dxg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=rT+906gUpbgXe2Cf5tInTJFgiDaoTeTRrwweMGxM5+oexNfN3voivbRU1tOYeyiluMnoXQnR1xctNWt4bbFh4iBFG9mvr/2AO2L7ttJ4NwWLXM7ahbfA5rP6NbKQrAlsKFEDaj/w4uBqNIJzq2F9ZG8CDSjlajkz7bmv/Jf4FwE= Received: by 10.141.41.12 with SMTP id t12mr2087631rvj.1185859401416; Mon, 30 Jul 2007 22:23:21 -0700 (PDT) Received: from ?133.88.3.33? ( [203.87.136.43]) by mx.google.com with ESMTPS id b34sm6288826rvf.2007.07.30.22.23.17 (version=SSLv3 cipher=RC4-MD5); Mon, 30 Jul 2007 22:23:20 -0700 (PDT) Subject: Re: [NOVICE] alter table table add column From: Ronald Rojas To: Michael Glaesemann Cc: pgsql-general@postgresql.org In-Reply-To: <7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net> References: <1185855587.28634.6.camel@localhost> <7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net> Content-Type: multipart/alternative; boundary="=-nP/62sg7AJCq8OiehIo6" Date: Tue, 31 Jul 2007 13:23:11 +0800 Message-Id: <1185859391.28634.17.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/1190 X-Sequence-Number: 117791 --=-nP/62sg7AJCq8OiehIo6 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, Sorry for doing the multiple mailing list recipient. Yes I know that procedure but I would like to insert in between because I have at third party software that will call the said schema and one of its dependencies with the mapping is it should have the correct order with what the receiving end will be use for the mapping. And in this case, I can't modify the receiving structure (third-party) and the tables that I will be using is in on production state. So would only mean that I have to schedule a very fast maintenance, probably 5 to 10 secs just to re-initialize the tables. Anyway, thanks for your input, really appreciate it. On Mon, 2007-07-30 at 23:32 -0500, Michael Glaesemann wrote: > [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 > > > ================================================================================================== 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. --=-nP/62sg7AJCq8OiehIo6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

Sorry for doing the multiple mailing list recipient. Yes I know that procedure but I would like to insert in between because I have at third party software that will call the said schema and one of its dependencies with the mapping is it should have the correct order with what the receiving end will be use for the mapping. And in this case, I can't modify the receiving structure (third-party) and the tables that I will be using is in on production state. So would only mean that I have to schedule a very fast maintenance, probably 5 to 10 secs just to re-initialize the tables.

Anyway, thanks for your input, really appreciate it.


On Mon, 2007-07-30 at 23:32 -0500, Michael Glaesemann wrote: 
[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




==================================================================================================
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.
--=-nP/62sg7AJCq8OiehIo6--