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.htmlhttps://www.postgresql.org/docs/10/static/information-schema.htmlhttps://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