Search Postgresql Archives

Re: Accessing system information functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <Johnson@xxxxxxxxxxxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux