Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 650419F931B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun,  5 Nov 2006 02:34:29 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 03665-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun,  5 Nov 2006 06:34:24 +0000 (UTC)
X-Greylist: delayed 00:16:56.023834 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 95AE99F9F0A
	for <pgsql-sql@postgresql.org>; Sun,  5 Nov 2006 02:34:24 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from localhost.localdomain (unknown [58.105.225.59])
	by svr4.postgresql.org (Postfix) with ESMTP id 1EADC5AF04F
	for <pgsql-sql@postgresql.org>; Sun,  5 Nov 2006 06:17:26 +0000 (GMT)
Received: from [127.0.0.1] ([192.168.1.5])
	by localhost.localdomain (8.13.1/8.12.11) with ESMTP id kA56HEiq013003
	for <pgsql-sql@postgresql.org>; Sun, 5 Nov 2006 17:17:21 +1100
Message-ID: <454D81EB.1010003@manngo.net>
Date: Sun, 05 Nov 2006 17:17:15 +1100
From: Mark Simon <mark@manngo.net>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Create View
Content-Type: multipart/alternative;
	boundary="------------070502040409000809010902"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.085 tagged_above=0 required=5 tests=BAYES_40,
	FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200611/51
X-Sequence-Number: 26703

This is a multi-part message in MIME format.
--------------070502040409000809010902
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 right question to search on.

If I create a view thus:

    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?

Thanks,

Mark

-- 


  Mark Simon

Manngo Net Pty Ltd

Phone/Fax: 1300 726 000
mobile: 0411 246 672

email: mark@manngo.net <mailto:mark@comparity.net>
web: http://www.manngo.net

Resume: http://mark.manngo.net


--------------070502040409000809010902
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<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 right question to search on.<br>
<br>
If I create a view thus:<br>
<br>
&nbsp;&nbsp;&nbsp; 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 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).<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>
<p>Phone/Fax: 1300 726 000<br>
mobile: 0411 246 672</p>
<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>
<p>Resume: <a href="http://mark.manngo.net">http://mark.manngo.net</a></p>
</div>
</div>
</body>
</html>

--------------070502040409000809010902--