Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about blocks. - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Question about blocks.
Date
Msg-id CAKFQuwYRQRksXBhahmOJMozWBQs=H1P1=iFVPCSg9VWryCUWGg@mail.gmail.com
Whole thread Raw
In response to Question about blocks.  (Chris Cawley <cj_cawley@yahoo.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Chris Cawley
Date:
Subject: Question about blocks.
Next
From: "Carrillo, Juan R"
Date:
Subject: postgresql repository question