After I got results from some query is there any name of temporary table created from those results???
+3
A:
No, but you can easily create a temporary table from the results of a select statement:
CREATE TEMPORARY TABLE temptablename AS
SELECT ...;
Then to get the result:
SELECT * FROM temptablename;
Mark Byers
2010-06-10 12:43:36
yea yea...i know what to do..after I do all steps I have to, just to DROP this table...this sql query I am goint to execute by php and then use pgsql2shp also in php.ok, now is everything clear in my head:)
Z77
2010-06-10 12:59:04
You don't have to drop the table - because it is created as temporary it is dropped automatically when the connection is closed.
Mark Byers
2010-06-10 12:59:49
aaa, ok:) that great than, one row less:)))
Z77
2010-06-10 13:08:07
Caveat: temporary tables are usually for interactive use; to use them in a web application, for example, is a dubious practice IMO.
leonbloy
2010-06-10 19:53:45
Yes. The intention is to be used for web application.
Z77
2010-06-11 07:31:01