From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Accessing system information functions |
Date: | 2023-09-25 12:28:52 |
Message-ID: | 9F887C2A-4715-4BCA-8ACF-8ECEB87E450D@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <Johnson(at)pharmacy(dot)arizona(dot)edu> wrote:
Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org repository
I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html
I’m logged on as the postgres superuser on the host
Trying any of the functions gives me a syntax error
postgres=# pg_database_size(avi);
ERROR: syntax error at or near "pg_database_size"
LINE 1: pg_database_size(avi);
Do I have to add anything to the search_path?
postgres=# show search_path;
search_path
-----------------
"$user", public
(1 row)
Select pg_database_size(avi);
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2023-09-25 12:31:27 | Re: Accessing system information functions |
Previous Message | Dave Cramer | 2023-09-25 12:27:48 | Re: Right version of jdbc |