On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.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.htmlI’m logged on as the postgres superuser on the hostTrying any of the functions gives me a syntax errorpostgres=# 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)
On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.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.htmlI’m logged on as the postgres superuser on the hostTrying any of the functions gives me a syntax errorpostgres=# 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)
postgres=# pg_database_size(avi);
ERROR: syntax error at or near "pg_database_size"
LINE 1: pg_database_size(avi);
postgres=# show search_path;
search_path
-----------------
"$user", public
(1 row)
And single quote name. 'avi'-- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
-- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
