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

[António M. Rodrigues]

For me the advantage is simple: I have a few plpgsql functions which create
tables with variables computed from some quite large tables. I then use
these tables as input to create other result tables (with geometry).

And yes, the advantage is not to deal with multiple deleting in the end of
each session.

As you say, perhaps the best is to contact Giuseppe Sucameli to see whether
this could be improved (if of course is an useful feature for other users).

Thanks,
António



2013/10/22 Andreas Neumann <a.neumann at carto.net>

> 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 <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/fb298af5/attachment.html>