pg-roles-visualization

Visualize the dependencies of the roles in your postgres rdbms

Usage with php

• edit the configuration (database connection parameters) in the roles.php file
• edit the roles.html configuration section
• put the files from the php folder in a webserver folder to make it accessible via a webservice

Usage with postgrest

• Download the postgrest binary from https://github.com/begriffs/postgrest/releases/latest

• execute the setup.sql in the postgrest directory of this repository in your preferred database. (I'd recommend to create a new one.)

• Invoke postgrest with these options (replace password, user and db-name as desired):

  ./postgrest --db-user postgres --db-name sclable --anonymous postgres --port 3000 --db-pass 123

• depending on the parameters, edit the config section in the roles.html

• open the roles.html file from the postgrest directory

Be Aware

• these scripts are for testing and demonstration purposes and not in any way ready for a production/live environment.