Skip to content

SQL - PostgreSQL - Information Schema Queries

*Source: *

Retrieve Tables from the information_schema

SELECT * FROM information_schema.tables;

Filter for a specific schema:

SELECT * FROM information_schema.tables WHERE table_schema = '<schema_name>';

Backlinks:

list from [[SQL - PostgreSQL Information Schema Queries]] AND -"Changelog"