X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 4457E31074E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 30 Jun 2003 13:07:44 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 85739-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 30 Jun 2003 10:07:33 -0300 (ADT)
Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222])
	by svr1.postgresql.org (Postfix) with ESMTP id 4C41A30F4CA
	for <pgsql-sql@postgresql.org>; Mon, 30 Jun 2003 10:07:33 -0300 (ADT)
Received: from css120.ihs.com (css120.ihs.com [170.207.105.120])
	by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h5UD6xA0008315;
	Mon, 30 Jun 2003 07:06:59 -0600 (MDT)
Date: Mon, 30 Jun 2003 07:01:25 -0600 (MDT)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Abdul Wahab Dahalan <wahab@mimos.my>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: select column from table
In-Reply-To: <3EFFF4DD.4060501@mimos.my>
Message-ID: <Pine.LNX.4.33.0306300700460.13665-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-MailScanner: Found to be clean
X-MailScanner-SpamCheck: 
X-Archive-Number: 200306/337
X-Sequence-Number: 14095

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;