pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

select column from table
2+ messages / 2 participants
[nested] [flat]

* select column from table
@ 2003-06-30 08:29  Abdul Wahab Dahalan <wahab@mimos.my>
  0 siblings, 1 reply; 2+ messages in thread

From: Abdul Wahab Dahalan @ 2003-06-30 08:29 UTC (permalink / raw)
  To: pgsql-sql

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?

Thanks.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: select column from table
@ 2003-06-30 13:01  scott.marlowe <scott.marlowe@ihs.com>
  parent: Abdul Wahab Dahalan <wahab@mimos.my>
  0 siblings, 0 replies; 2+ messages in thread

From: scott.marlowe @ 2003-06-30 13:01 UTC (permalink / raw)
  To: Abdul Wahab Dahalan <wahab@mimos.my>; +Cc: 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;




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-06-30 13:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-30 08:29 select column from table Abdul Wahab Dahalan <wahab@mimos.my>
2003-06-30 13:01 ` scott.marlowe <scott.marlowe@ihs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox