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

[Andreas Neumann]

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
>>>
>>
>>
>