Re: select column from table - Mailing list 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;