Accessing system information functions

From: "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Accessing system information functions
Date: 2023-09-22 17:37:39
Message-ID: 5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org<http://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)

--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad White 2023-09-22 18:18:38 Re: How to fork pg_dump or psql w/o leaking secrets?
Previous Message Dominique Devienne 2023-09-22 15:51:37 Re: How to fork pg_dump or psql w/o leaking secrets?