Create View - Mailing list pgsql-sql

From Mark Simon
Subject Create View
Date
Msg-id 454D81EB.1010003@manngo.net
Whole thread Raw
Responses Re: Create View
List pgsql-sql
<tt>I don't know whether this is a simple one that has been dealt with before, but if so, I haven't worked out the
rightquestion to search on.<br /><br /> If I create a view thus:<br /><br />     create view things as select * from
whatever;<br/><br /> and then examine my saved view, I find a list of all of the fields from whatever. I thought it
shouldbe possible to save the star (*) as part of the view. Otherwise, I run into the problem of not getting all of the
fieldsif I add columns to the table (whatever).<br /><br /> Is this an SQL thing or a PostGreSQL thing?<br /><br />
Thanks,<br/><br /> Mark<br /><br /></tt><div class="moz-signature">-- <br /><style>#signature {    color: #00008B;
font-family:sans-serif;    font-size: 10pt;}#signature h1 {    font-size: 125%;    margin: 4px 0px;}#signature p {
margin:4px 0px;}#signature a {    color: #005247;    text-decoration: none;}
 
</style><div id="signature"><h1>Mark Simon</h1><p>Manngo Net Pty Ltd<p>Phone/Fax: 1300 726 000<br /> mobile: 0411 246
672<p>email:<a href="mailto:mark@comparity.net">mark@manngo.net</a><br /> web: <a
href="http://www.manngo.net">http://www.manngo.net</a><p>Resume:<a
href="http://mark.manngo.net">http://mark.manngo.net</a></div></div>

pgsql-sql by date:

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