Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL System Views or Dictionary Tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: PostgreSQL System Views or Dictionary Tables
Date
Msg-id CAKFQuwYUQO5w2ZR1iZ-P+atO+-icKdE2_x9G9h=HXkNbtUEiBA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL System Views or Dictionary Tables  (Diego Grampin <dgrampin@tilsor.com.uy>)
List pgsql-general
Tree view
On Thu, Aug 16, 2018 at 2:06 PM, Diego Grampin <dgrampin@tilsor.com.uy> wrote:
Hello,

I'm new at PostgreSQL, but known Oracle since ten years ago.

In PostgreSQL, where can i found system views or dictionary tables (v$*, dba_* at oracle) or structural dba tables ?. And comand prompt parameters of the database (show param X at Oracle) ?
The porpose of this is to familiarized with the structure of Postgresql databases.

My test environment: Windows physical server machine intel x86-64 architecture with PostgreSQL Database version 10.5 and pgAdmin 4 version 3.2 .

https://www.postgresql.org/docs/10/static/index.html

Section VII is internals - the "structural dba tables" are termed "System Catalogs" in PostgreSQL.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL System Views or Dictionary Tables
Next
From: Raghavendra Rao J S V
Date:
Subject: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?