Re: Accessing system information functions

[Rob Sargent]

On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <john...@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.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) And single quote name. 'avi' --  Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs