Skip site navigation (1)
Skip section navigation (2)
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-general(at)postgresql(dot)org
- Subject: Re: [NOVICE] alter table table add column
- Date: Tue, 31 Jul 2007 00:56:11 -0500
On Jul 31, 2007, at 0:23 , Ronald Rojas wrote:
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.
Another option would be to use views to change the column order, which would work for selects. I believe you could create rules for insert and update as well, if necessary. Perhaps this would be a solution to your problem.
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
- Re: [NOVICE] alter table table add column
- From: Michael Glaesemann
- Re: [NOVICE] alter table table add column
- From: Ronald Rojas
- alter table table add column
- Prev by Date: Re: [NOVICE] alter table table add column
- Next by Date: Re: plperl syntax highlighting for vi
- Previous by thread: Re: [NOVICE] alter table table add column
- Next by thread: Re: [NOVICE] alter table table add column
- Indexes: