Hi RPK
My suggestion would be to create a view which presents the columns as
you wish.
eg
CREATE OR REPLACE VIEW tableView AS
SELECT a, b, c
FROM table
Then when you add add a new column, just adjust the view as required.
Cheers
Noel
RPK wrote:
Andreas,
I am talking about inserting a f
RPK <[EMAIL PROTECTED]> schrieb:
>
> Andreas,
>
> I am talking about inserting a field or changing their order in the
> structure itself. In MS Access and SQL Server we have this facility. Some
> times I need to shift the less important field to the last so that when I
> query using:
>
> Select
RPK wrote on 25.02.2007 09:44:
Select * from tablename;
the un-necessary field gets displayed in the last. However, you I can ignore
that field altogether using filtered fields only in Select statement, but
still sometimes it is necessary.
No it's not. SELECT * should be avoided by all means (
Andreas,
I am talking about inserting a field or changing their order in the
structure itself. In MS Access and SQL Server we have this facility. Some
times I need to shift the less important field to the last so that when I
query using:
Select * from tablename;
the un-necessary field gets disp
am Sat, dem 24.02.2007, um 23:08:05 -0800 mailte RPK folgendes:
>
> I think pgsql front-end needs this facility in future.
No. You can specify the column-order in the SELECT or INSERT - command.
And you can do it with regular SQL. PostgreSQL possesses transactions.
>
>
> Joshua D. Drake wrote:
I think pgsql front-end needs this facility in future.
Joshua D. Drake wrote:
>
> RPK wrote:
>> I want to know whether I can insert a new column in between in an
>> existing
>> table. My table has 10 fields and I want to insert a field after third
>> field.
>
> Not without recreating the table
RPK wrote:
> I want to know whether I can insert a new column in between in an existing
> table. My table has 10 fields and I want to insert a field after third
> field.
Not without recreating the table.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
I want to know whether I can insert a new column in between in an existing
table. My table has 10 fields and I want to insert a field after third
field.
--
View this message in context:
http://www.nabble.com/Inserting-a-new-column-in-between.-tf3286148.html#a9140871
Sent from the PostgreSQL - ge