Обсуждение: PostgreSQL System Views or Dictionary Tables

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.

On 08/16/2018 02:06 PM, Diego Grampin 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.

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

https://www.postgresql.org/docs/10/static/information-schema.html

https://www.postgresql.org/docs/10/static/sql-show.html

> 
> _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.


-- 
Adrian Klaver
adrian.klaver@aklaver.com