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.kla...@aklaver.com
