On Mon, 23 Dec 2002, [iso-8859-1] [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster