ok - wasn't aware of that. What is the advantage of using these temp tables? That you do not have to deal with deleting the table?
I am not too familiar with the internals of db-manager. Does it establish a session? Probably Giuseppe Sucameli can help. Andreas Am 22.10.2013 14:10, schrieb António M. Rodrigues: > In postgres I can use 'create temporary table...' which will create a new > object which only exists in the present session. It can only be stored in > special schemas (which can be accessed from layer--> add postgis layer), > called pg_tmp_'some integer'. > > I was just saying it would be nice to be able to browse these objects in > db_manager. Of course I can do this in the command line with psql. > > António > > > 2013/10/22 Andreas Neumann <[email protected]> > >> What do you mean by "temp tables"? >> >> There are no "temp tables" in a database. Either it is a table, a view >> or a table. All of these can already be opened with DB manager. >> >> Andreas >> >> Am 22.10.2013 13:57, schrieb António M. Rodrigues: >>> The thing is I have some custom functions which output temp tables. And >> it >>> would be useful to be able to explore these tables in db-manager. >>> >>> I guess it shouldn't be too difficult to tweak dbmanager. >>> I was looking at the source code for but unfortunately my knowledge of >>> pyqgis is not quite there (maybe one day... :--) ). >>> >>> António >>> >>> >>> 2013/10/22 Andreas Neumann <[email protected]> >>> >>>> Hi, >>>> >>>> You can load query results in db-manager. >>>> >>>> Just create a query in db-manager, select the primary key column and the >>>> geometry column and load it. >>>> >>>> Works fine for me. >>>> >>>> Andreas >>>> >>>> Am 22.10.2013 13:42, schrieb António M. Rodrigues: >>>>> Hi, >>>>> >>>>> Is there a way to access temporary tables through db-manager? >>>>> >>>>> From what I get, this is only possible through layer->add postgis layer >>>>> (also not available in the browser panel). >>>>> >>>>> Thanks, >>>>> António >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Qgis-user mailing list >>>>> [email protected] >>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>>>> >>>> >>>> _______________________________________________ >>>> Qgis-user mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> >> > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
