From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Abdul Wahab Dahalan <wahab(at)mimos(dot)my> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: select column from table |
Date: | 2003-06-30 13:01:25 |
Message-ID: | Pine.LNX.4.33.0306300700460.13665-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Mon, 30 Jun 2003, Abdul Wahab Dahalan wrote:
> Hi everybody!
>
> I just want to know is there a way in SQL command that can handle column
> selection?.
> The case is :
> If I've a table with 10 columns and I want to select 8 of them without
> rewrite the columns/fields name in the SQL query?
> eg : Current SQL query is :- Select a,b,c,d,e,f,g,h from abctable; -
> greps 8 columns
> Can SQL do something like Select * from abctable without i,j ? -
> greps all 8 columns?
Not really like that, but you can create a view:
create view test as selct a,b,c,d,e,f,g,h from table
then
select * from test;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-30 14:26:55 | Re: Seqno. is not btree? |
Previous Message | Bruno Wolff III | 2003-06-30 12:42:49 | Re: Bitwise operation |