Re: Question about blocks.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Chris Cawley <cj_cawley(at)yahoo(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Question about blocks.
Date: 2022-01-25 16:25:26
Message-ID: CAKFQuwYRQRksXBhahmOJMozWBQs=H1P1=iFVPCSg9VWryCUWGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jan 25, 2022 at 8:55 AM Chris Cawley <cj_cawley(at)yahoo(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Carrillo, Juan R 2022-01-25 18:44:53 postgresql repository question
Previous Message Chris Cawley 2022-01-25 15:54:44 Question about blocks.