Re: Create View

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: Mark Simon <mark(at)manngo(dot)net>
Subject: Re: Create View
Date: 2006-11-05 07:38:56
Message-ID: 200611050838.56984.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mark Simon wrote:
> create view things as select * from whatever;
>
> and then examine my saved view, I find a list of all of the fields
> from whatever. I thought it should be possible to save the star (*)
> as part of the view. Otherwise, I run into the problem of not getting
> all of the fields if I add columns to the table (whatever).
>
> Is this an SQL thing or a PostGreSQL thing?

SQL

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message imad 2006-11-05 11:59:14 Re: Create Function (SQL)
Previous Message Mark Simon 2006-11-05 06:21:00 Create Function (SQL)