problem with TEMPORARY TABLE
- by Z77
Within PHP I do:
1.) A temporary table is created: CREATE TEMP TABLE new_table AS SELECT .... FROM ...;
2.) AFter that I want to use this table to create a shape file: shell_exec ("pgsql2shp .... -u username -P password ...);
Separetly those two things work, but by creating a temporary table and after that using this table in pgsql2shp does not work. I pressume this is because temporary table duration is to the end of session. But to create shp file I need to use username and password what means new session starts and temporary table is dropped before I use it for shape creation.
Any tip how to solve it?
Thank you!
