[Qgis-user] db-manager (temporary tables)

[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 <a.neumann at 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.neumann at 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 at lists.osgeo.org
> >>> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >>>
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131022/aa38d2e3/attachment.html>