Re: PostgreSQL System Views or Dictionary Tables

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(dot)klaver(at)aklaver(dot)com