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!
Hi All,
Do We have any script to recreate specific schema users before we start any schema refresh from prod to UAT ?
I need to script out all logins with permissions and roles assigned to UAT before prod schema refresh…
Thank you
Kris k