Hi
po 25. 9. 2023 v 19:51 odesílatel Rob Sargent <robjsargent@xxxxxxxxx> napsal:
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)
you are missing SELECT keyword
(2023-09-25 20:05:08) postgres=# select pg_database_size('postgres');
┌──────────────────┐
│ pg_database_size │
╞══════════════════╡
│ 7901667 │
└──────────────────┘
(1 row)
┌──────────────────┐
│ pg_database_size │
╞══════════════════╡
│ 7901667 │
└──────────────────┘
(1 row)
Regards
Pavel
And single quote name. 'avi'--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
