[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] select column from table
From:       "scott.marlowe" <scott.marlowe () ihs ! com>
Date:       2003-06-30 13:01:25
[Download RAW message or body]

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;


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]