-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Il 22/10/2013 15:42, Jrgen E. Fischer ha scritto:
> QGIS and the db_manager use separate sessions. I didn't try, but I doubt that
> you can load temporary layers created by db_manager into qgis.
you can, however, run a query and load its results as
Hi Jürgen,
Thanks for that.
I did some testing following your e-mail.
After creating a layer in db_manager, I tried to load it and got an error:
dbname='testes'(...)key='r_table_catalog'
table="pg_temp_7"."nnn2" sql= is an invalid layer - not loaded
I guess I'll have to think of an
Hi António,
On Tue, 22. Oct 2013 at 13:29:57 +0100, António M. Rodrigues wrote:
> 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).
QGIS and the db_manager use separate sessions. I didn't tr
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 s
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ón
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 t
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 table
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 (m
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-mana
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
h
10 matches
Mail list logo