Beekeeper Studio
beekeeperstudio.io › blog › postgres-information-schema
Understanding PostgreSQL Information_Schema Views | Beekeeper Studio
April 8, 2024 - Information_schema is a system catalog that forms a standard set of views which contains information about the PostgreSQL database objects, essentially, it’s a meta-database that holds information about your current database.
PostgreSQL
postgresql.org › docs › current › information-schema.html
PostgreSQL: Documentation: 18: Chapter 35. The Information Schema
May 14, 2026 - ... Unsupported versions: 13 / ... 8.0 / 7.4 ... The information schema consists of a set of views that contain information about the objects defined in the current database....
Medium
tomasz-gintowt.medium.com › postgresql-information-schema-with-practical-examples-604c250a4065
PostgreSQL information_schema (With Practical Examples) | by Tomasz Gintowt | Medium
November 14, 2025 - The information_schema is a collection of read-only views that provide structured information about all database objects. Because it follows the SQL standard, the same queries work across many relational databases (e.g., MySQL, MariaDB, SQL Server).
Beekeeper Studio
beekeeperstudio.io › blog › postgresql-information-schema
PostgreSQL Information_Schema Guide for Database Management | Beekeeper Studio
April 9, 2024 - The information_schema is a critical feature in PostgreSQL databases that provides access to the ‘current database’ metadata. It is essentially a collection of views that contain information on various objects in the ‘current database”. From tables to columns to constraints, PostgreSQL’s information_schema provides the detaiils of a database’s architecture.
Neon
neon.com › postgresql › postgresql-views › postgresql-list-views
PostgreSQL List Views
PostgreSQL offers some options for listing views within the current database. You can either use the \dv command in psql or query the information_schema.views and pg_matviews views directly.
Reddit
reddit.com › r/postgresql › how can i view information_schema in pgadmin4
r/PostgreSQL on Reddit: How can I view information_schema in pgAdmin4
November 4, 2022 -
So I'm new to Postgres and I want to have a look at how postgres stores schema data since I am building a database manager like pgAdmin as a hobby project. My understanding is that all the schema data like names of tables and columns, column types, etc is stored in the `information_schema` table, however I cannot find the `information_schema` table anywhere in pgAdmin.
Edit: sorry I meant tables named eg `information_schema.tables`, not a table named `information_schema`
Edit 2: Having read more about Postgres, I think "metadata" is a more accurate word for what I was looking for than "schema" which is the language used by SQLite which I was using previously.
Top answer 1 of 2
1
Why not just use: select * from information_schema.tables
2 of 2
1
Not sure about pgAdmin presenting this info or not (it mostly uses the information to show you the GUI elements in the tree), but the official location of all database metadata is the system catalogs, collectively accessed via the pg_catalog schema. The information_schema schema contains standard mandated views of similar information; but not everything in PostgreSQL conforms to (or even exists in) the standard and so using information_schema has its limitations. You are probably better off just reviewing the documentation for these two schemas, especially as they contain notes and descriptions.
CastorDoc
castordoc.com › how-to › how-to-use-informationschema-in-postgresql
How to use INFORMATION_SCHEMA in PostgreSQL?
Additionally, the INFORMATION_SCHEMA provides views that expose information about database constraints, indexes, views, and more. This allows you to gather insights into the relationships between your database objects and perform advanced analysis ...
RazorSQL
razorsql.com › articles › postgresql_system_queries.html
PostgreSQL System Queries for Getting Tables, Schemas, Databases, Views, Indexes, Functions, and Triggers
Postgres table information can be retrieved either from the information_schema.tables view, or from the pg_catalog.pg_tables view.
Database Guide
database.guide › how-to-list-all-views-in-a-postgresql-database
How to List All Views in a PostgreSQL Database
In PostgreSQL, we can use the information_schema.views view to return all views in a database.
Top answer 1 of 7
91
From the documentation:
select table_name from INFORMATION_SCHEMA.views;
If you don't want the system views is your result, try this:
select table_name from INFORMATION_SCHEMA.views WHERE table_schema = ANY (current_schemas(false))
2 of 7
38
You can query pg_catalog.pg_views for your desired information:
select viewname from pg_catalog.pg_views;
Refined query to get schema name also - just in case you have multiple views with the same name in different schemas - and left out those system views:
select schemaname, viewname from pg_catalog.pg_views
where schemaname NOT IN ('pg_catalog', 'information_schema')
order by schemaname, viewname;
IMHO, this way is better than query INFORMATION_SCHEMA.views for reasons stated in my comment to Phil's answer.
Google Cloud
cloud.google.com › spanner › information schema for postgresql-dialect databases
Information schema for PostgreSQL-dialect databases | Spanner | Google Cloud Documentation
Return the name of all tables and views in the information_schema for PostgreSQL-dialect databases:
PostgreSQL
postgresql.org › docs › current › infoschema-views.html
PostgreSQL: Documentation: 18: 35.66. views
May 14, 2026 - 35.66. views # The view views contains all views defined in the current database. Only those views are shown that the …
pgPedia
pgpedia.info › i › information-schema.html
Information schema - pgPedia - a PostgreSQL Encyclopedia
SQL commands System catalog tables ... versions @pgpedia.info (Bluesky) ... The information schema is a special schema with standard views containing information about the objects defined in the current database....
Tuttlem
tuttlem.github.io › 2016 › 01 › 10 › information_schema-with-postgresql.html
information_schema with PostgreSQL · Cogs and Levers
The information_schema in PostgreSQL holds a lot of really handy views with information about the current database.
CommandPrompt Inc.
commandprompt.com › education › how-to-list-views-in-postgresql
How to List Views in PostgreSQL — CommandPrompt Inc.
February 1, 2023 - So, click on the “public” schema ... “\dv”, “\dv+” commands, “information_schema.views”, etc., are used to list all the views from a database....
PostgreSQL
postgresql.org › docs › current › infoschema-tables.html
18: 35.54. tables - PostgreSQL: Documentation
May 14, 2026 - June 4, 2026: PostgreSQL 19 Beta 1 Released! ... Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 · The view tables contains all tables and views defined in the current database.
Postgresscripts
postgresscripts.com › post › list-postgresql-database-views
List All Views in a PostgreSQL Database with SQL | Postgres Scripts
May 22, 2026 - 1SELECT 2 table_schema AS view_schema, 3 table_name AS view_name, 4 view_definition 5FROM 6 information_schema.views 7WHERE 8 table_schema NOT IN ('pg_catalog', 'information_schema') 9ORDER BY 10 table_schema, 11 table_name; Notes: Works on any version of PostgreSQL.
PostgreSQL
postgresql.org › docs › 9.1 › information-schema.html
PostgreSQL: Documentation: 9.1: The Information Schema
October 27, 2016 - You may want to view the same page for the current version, or one of the other supported versions listed above instead. ... The information schema consists of a set of views that contain information about the objects defined in the current database.
Airbyte
airbyte.com › home › data engineering resources › postgresql list all schemas in database
How to List All Schemas in the PostgreSQL Database: An Ultimate Guide | Airbyte
September 9, 2025 - PostgreSQL lets you list schemas via information_schema.schemata or pg_catalog.pg_namespace, showing names, privileges, and sizes. You can join system catalogs to view access controls or summarize schema disk usage, aiding auditing, optimization, and database management.