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 <a.neum...@carto.net> > 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 <a.neum...@carto.net> > > > >> 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 > >>> Qgis-user@lists.osgeo.org > >>> http://lists.osgeo.org/mailman/listinfo/qgis-user > >>> > >> > >> _______________________________________________ > >> Qgis-user mailing list > >> Qgis-user@lists.osgeo.org > >> http://lists.osgeo.org/mailman/listinfo/qgis-user > > > >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user