PostgreSQL System Views or Dictionary Tables

From: Diego Grampin <dgrampin(at)tilsor(dot)com(dot)uy>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL System Views or Dictionary Tables
Date: 2018-08-16 21:06:07
Message-ID: 1d7fb1b9-2057-a8cc-b336-c7f43bb4dbf3@tilsor.com.uy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-08-16 21:11:42 Re: PostgreSQL System Views or Dictionary Tables
Previous Message Stephen Frost 2018-08-16 16:53:18 Re: pg_upgrade (and recovery) pitfalls