Postgres Pro
Downloads
Home   >   mailing lists

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

From Diego Grampin
Subject PostgreSQL System Views or Dictionary Tables
Date
Msg-id 1d7fb1b9-2057-a8cc-b336-c7f43bb4dbf3@tilsor.com.uy
Whole thread Raw
Responses Re: PostgreSQL System Views or Dictionary Tables
Re: PostgreSQL System Views or Dictionary Tables
List pgsql-general
Tree view
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 .

Thanks so much for your help.
Regards,
Diego.

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_upgrade (and recovery) pitfalls
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL System Views or Dictionary Tables