Re: PostgreSQL System Views or Dictionary Tables

"David G. Johnston" <david.g.johnston@xxxxxxxxx> · Thu, 16 Aug 2018 14:12:02 -0700

On Thu, Aug 16, 2018 at 2:06 PM, Diego Grampin <dgrampin@xxxxxxxxxxxxx> 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.