Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 601C1475DD0
	for <pgsql-sql@postgresql.org>; Mon, 23 Dec 2002 06:05:50 -0500 (EST)
Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP id A81B6475AE4
	for <pgsql-sql@postgresql.org>; Mon, 23 Dec 2002 06:05:48 -0500 (EST)
Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50])
	by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id gBNF9ppL030653;
	Mon, 23 Dec 2002 13:09:51 -0200
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id
	gBNF9pXn030649; Mon, 23 Dec 2002 13:09:51 -0200
Date: Mon, 23 Dec 2002 13:09:51 -0200 (GMT+2)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: "=?iso-8859-1?Q?mzmaxmail@libero.it?=" <mzmaxmail@libero.it>
Cc: =?iso-8859-1?Q?pgsql-sql?= <pgsql-sql@postgresql.org>
Subject: Re: =?iso-8859-1?Q?_save_data_from_views?=
In-Reply-To: <H7KJSJ$95D28F4D33EA2C2B39CFDF28267BDAA8@libero.it>
Message-ID: <Pine.LNX.4.44.0212231306001.30640-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/261
X-Sequence-Number: 10849

On Mon, 23 Dec 2002, [iso-8859-1] mzmaxmail@libero.it wrote:

>
>
>
>  first of all, thanx for anyone who answered my previous question... i've understood what was wrong...
> now, i've got another question, i know it could sound stupid, but i have not such a great practice with postgres. i'm asking you: is it that a way to save values from a view?
> i'm using postgres to calculate pollutant emissions by cars, and i make some queries and create views. i would like to save the results from the views but i can't find a way to export them.
> once again thanx in advance for your help, massimo

You could write a program in your favourite language that selects and
prints the rows of your views.

Also you could
# create table tempviewdata as select * from <your view name>;

Why would you want to save the values of your views??

>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr