Обсуждение: Question about blocks.

Поиск
Список
Период
Сортировка

Question about blocks.

От
Chris Cawley
Дата:
All -

I have the sql to check for blocks; however , it is per server or per database?
Do I need to connect to each database and check.  This would mean that I
need a list first and then cycle through.

Thanks
Chris

Re: Question about blocks.

От
"David G. Johnston"
Дата:
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.