PostgreSQL Data Dictionary Query Toolbox

Databases and schemas

List databases on PostgreSQL instance
List schemas in PostgreSQL database
List user created schemas in PostgreSQL database

Tables

List tables in PostgreSQL database
List tables in PostgreSQL database schema

Columns

List table columns in PostgreSQL database
List all columns in specific table in PostgreSQL database

Views

List views in PostgreSQL database
List views in PostgreSQL database with their scripts
List views columns in PostgreSQL
List tables used by a view in PostgreSQL database
List materialized views in PostgreSQL database

Primary keys

List all primary keys (PKs) in PostgreSQL database
List all primary keys (PKs) and their columns in PostgreSQL database
List tables with their primary keys (PKs) in PostgreSQL database
Find tables without primary keys (PKs) in PostgreSQL database
How many tables don't have primary keys (with percentage) in PostgreSQL database

Foreign keys

List foreign keys in PostgreSQL database
List foreign keys with columns in PostgreSQL database
List table columns with their foreign keys in PostgreSQL database
List all tables refrenced by specific table (by FK) in PostgreSQL database
List all tables refrencing specific table (by FK) in PostgreSQL database
List tables with most foreign keys in PostgreSQL database
List most referenced tables in PostgreSQL database (by FK)
List tables with most relationships in PostgreSQL database
Find tables without foreign keys in PostgreSQL database
Find tables that are not referenced by the foreign keys in PostgreSQL database
Find tables without relationships - Loner Tables - in PostgreSQL database
Loner Ratio - how many tables have no relationships in PostgreSQL database

Check constraints

List all check constraints in PostgreSQL database
List table check constraints in PostgreSQL database

Default values

List table default values in PostgreSQL database
Summary of default values in PostgreSQL database

Constraints

Find required (non nullable) columns in PostgreSQL database
Check if is column nullable in PostgreSQL database

Data types

Find most used data type in PostgreSQL database
Find all numeric columns in PostgreSQL database
Find all string (character) columns in PostgreSQL database
Find all date and time columns in PostgreSQL database
Find all geometric data columns in PostgreSQL database
Find all enum columns in PostgreSQL database
Find all XML data columns in PostgreSQL database
Find all JSON data columns in PostgreSQL database
Find all semi-structured data columns in PostgreSQL

Triggers

List table triggers in PostgreSQL database

Functions and stored procedures

List user defined functions (UDFs) in PostgreSQL database
List stored procedures in PostgreSQL database
List stored procedure parameters in PostgreSQL database

Searching schema

Find a table by the name in PostgreSQL database
Find tables with names with specific prefix in PostgreSQL database
Find tables with names with specific suffix in PostgreSQL database
Find tables with specific word in name in PostgreSQL database
Find tables with digits in names in PostgreSQL database
Find tables with specific column name in PostgreSQL database
Find table that DON'T have a column with specific name in PostgreSQL database

Schema statistics

Find number of tables in PostgreSQL database
Find number of columns in PostgreSQL database
List tables with the largest number of columns in PostgreSQL database
Average number of columns per table in PostgreSQL database

Schema naming

Find most popular column names in PostgreSQL database
Get column name length distribution in PostgreSQL database
List columns by name length in PostgreSQL database

Security and users

List users in PostgreSQL database

Session

List sessions / active connections in PostgreSQL database
Find last query executed by specific session in PostgreSQL database
Terminate (kill) specific session in PostgreSQL database

Environment

How to check the PostgreSQL version
How to find operating system (OS) that PostgreSQL server runs on

Number of rows

List tables by the number of rows in PostgreSQL database
Find empty tables in PostgreSQL database
Number of tables by the number of rows in PostgreSQL database

Data size

List tables by their size in PostgreSQL database
List tables by the size of data and indexes in PostgreSQL database
List 10 largest tables in PostgreSQL database
List tables that take up 50% of space in PostgreSQL database

Schema compare

Compare tables and columns in two schemas in PostgreSQL database

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.

There are no comments. Click here to write the first comment.

Supported Technologies

Metadata Management: Why Start Now?

Why Dataedo?

Dataedo Cartoons

PostgreSQL Data Dictionary Query Toolbox

Supported
Technologies