Re: Create View - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Create View
Date
Msg-id 200611050838.56984.peter_e@gmx.net
Whole thread Raw
In response to Create View  (Mark Simon <mark@manngo.net>)
List 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/


pgsql-sql by date:

Previous
From: Mark Simon
Date:
Subject: Create Function (SQL)
Next
From: imad
Date:
Subject: Re: Create Function (SQL)