Hello Krishna,
Which Editor you are referring in your email?
Actually, I am trying to use such Editor. Currently I am using pgAdmin and SQL- Developer to connect Postgres databases but the editor features which are available are not meeting the demands. I am just trying to know if you are using any other editor from
any other tools or using any other way.
From PSql, we can only run SQL queries to get the desired results.
For example, if I click on the user or table in the editors, I want to fetch all the SQLs related all privilege assignments on that object. This is not my just theory but I worked on this type of environment in the past and now I missing them.
Thank you,
Sarwar
From: SOzcn <selahattinozcnma@xxxxxxxxx>
Sent: Thursday, December 21, 2023 3:23 PM To: Krishna B <krishnasvkb@xxxxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Subject: Re: Login script Hello,
You can have the DDL from editors or in the psql. For users you can get the information from pg_authit select rolname,rolpassword from pg_authid where rolname='postgres'; Have a nice day! Krishna B <krishnasvkb@xxxxxxxxx>, 21 Ara 2023 Per, 22:42 tarihinde şunu yazdı:
Hi All, |