Re: Question about blocks.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Question about blocks.
Дата
Msg-id CAKFQuwYRQRksXBhahmOJMozWBQs=H1P1=iFVPCSg9VWryCUWGg@mail.gmail.com
обсуждение исходный текст
Ответ на Question about blocks.  (Chris Cawley <cj_cawley@yahoo.com>)
Список pgsql-admin
Дерево обсуждения
On Tue, Jan 25, 2022 at 8:55 AM Chris Cawley <cj_cawley@yahoo.com> wrote:
I have the sql to check for blocks; however , it is per server or per database?

Given it is SQL access I would presume it is per-table, which are per-database.  Seems easy enough to test...since you haven't shown the SQL for others to evaluate.

This would mean that I need a list first and then cycle through.

SELECT * FROM pg_database;

David J.

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

Предыдущее
От: Chris Cawley
Дата:
Сообщение: Question about blocks.
Следующее
От: "Carrillo, Juan R"
Дата:
Сообщение: postgresql repository question