Getting active PostgreSQL connection username when stored through authentication configuration in QGIS 3.16

Question

How do I get the username on the current layer PostGIS in QGIS 3.16.2-Hannover? We tried examples: Getting active PostgreSQL connection username when stored through authentication configuration in QGIS 3, but they don't work.

When running this script, variable username is empty:

layer = iface.activeLayer()
provider = layer.dataProvider()
username = QgsDataSourceUri(provider.dataSourceUri()).username()
print (username)

This is result of provider.dataSourceUri()):

<QgsDataSourceUri: dbname='postgres' host= localhost port=5432 sslmode=disable key='id' srid=4326 type=Point checkPrimaryKeyUnicity='1' table="locations"."airlines" (geom)>

The value of the username is missing, the question is how to get the username for the current layer?

I have tried it as well. I got also username is empty but the reason (in my case) I am connected with local credentials so there is no user and psw. Can you check if you see the 'user' when you print out provider.dataSourceUri()? — Nil
– Nil, Commented Jan 10, 2021 at 13:39
I don't understand: you are referring to a question that gives you the solution, doesn't it ? — dd_a
– dd_a, Commented Jan 10, 2021 at 16:33
the solution to the question I am referring to does not answer my question. Function - QgsDataSourceUri(provider.dataSourceUri()).username() return empty string — Andrey Sirbu
– Andrey Sirbu, Commented Jan 11, 2021 at 8:05
@AndreySirbu what does it return if you call only provider.dataSourceUri()?? — Nil
– Nil, Commented Jan 11, 2021 at 8:11

Encomium · Accepted Answer · 2021-06-03 22:20:33Z

0

You can select your PostgreSQL user using the 'PostgreSQL Execute SQL' command in the Processing toolbox.

Query:

SELECT user;

answered Jun 3, 2021 at 22:20

Encomium

3,2232 gold badges17 silver badges42 bronze badges

how to get user name from script?

Andrey Sirbu
– Andrey Sirbu

2021-08-13 07:50:01 +00:00
Commented Aug 13, 2021 at 7:50
How to use python function?

Andrey Sirbu
– Andrey Sirbu

2023-10-18 05:17:29 +00:00
Commented Oct 18, 2023 at 5:17

Add a comment |

Stack Exchange Network

Getting active PostgreSQL connection username when stored through authentication configuration in QGIS 3.16

1 Answer 1

Your Answer

Linked

Hot Network Questions

Getting active PostgreSQL connection username when stored through authentication configuration in QGIS 3.16

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions