pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed save data from views
3+ messages / 2 participants
[nested] [flat]
* save data from views
@ 2002-12-23 10:57 mzmaxmail@libero.it <mzmaxmail@libero.it>
2002-12-23 15:09 ` Re: save data from views Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 3+ messages in thread
From: mzmaxmail@libero.it @ 2002-12-23 10:57 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: save data from views
2002-12-23 10:57 save data from views mzmaxmail@libero.it <mzmaxmail@libero.it>
@ 2002-12-23 15:09 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Achilleus Mantzios @ 2002-12-23 15:09 UTC (permalink / raw)
To: mzmaxmail@libero.it <mzmaxmail@libero.it>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: save data from views
@ 2002-12-23 11:48 mzmaxmail@libero.it <mzmaxmail@libero.it>
0 siblings, 0 replies; 3+ messages in thread
From: mzmaxmail@libero.it @ 2002-12-23 11:48 UTC (permalink / raw)
To: achill <achill@matrix.gatewaynet.com>; +Cc: pgsql-sql
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??
thanx for your answer.
i'm developing a database that outputs pollutant emissions that has to be imported by the GRASS _ GIS program.
in that way i can produce vector maps of the city i'm studying with pollutant emissions as attributes.
to do this, i had to put the COPERT emissions model in the database, and create views to display all the results. but i also need to save this results, if i want to open them in other programs!!!
massimo
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-12-23 15:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-23 10:57 save data from views mzmaxmail@libero.it <mzmaxmail@libero.it>
2002-12-23 15:09 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-12-23 11:48 Re: save data from views mzmaxmail@libero.it <mzmaxmail@libero.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox