Re: PostgreSQL System Views or Dictionary Tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PostgreSQL System Views or Dictionary Tables
Дата
Msg-id CAKFQuwYUQO5w2ZR1iZ-P+atO+-icKdE2_x9G9h=HXkNbtUEiBA@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL System Views or Dictionary Tables  (Diego Grampin <dgrampin@tilsor.com.uy>)
Список pgsql-general
Дерево обсуждения
On Thu, Aug 16, 2018 at 2:06 PM, Diego Grampin <dgrampin@tilsor.com.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL System Views or Dictionary Tables
Следующее
От: Raghavendra Rao J S V
Дата:
Сообщение: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?