| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Diego Grampin <dgrampin(at)tilsor(dot)com(dot)uy> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL System Views or Dictionary Tables |
| Date: | 2018-08-16 21:12:02 |
| Message-ID: | CAKFQuwYUQO5w2ZR1iZ-P+atO+-icKdE2_x9G9h=HXkNbtUEiBA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 16, 2018 at 2:06 PM, Diego Grampin <dgrampin(at)tilsor(dot)com(dot)uy>
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.
>
> *My test environment:* Windows physical server machine intel x86-64
> architecture with PostgreSQL Database version 10.5 and pgAdmin 4 version
> 3.2 .
>
https://www.postgresql.org/docs/10/static/index.html
Section VII is internals - the "structural dba tables" are termed "System
Catalogs" in PostgreSQL.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra Rao J S V | 2018-08-17 01:10:48 | Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? |
| Previous Message | Adrian Klaver | 2018-08-16 21:11:42 | Re: PostgreSQL System Views or Dictionary Tables |