Hi po 25. 9. 2023 v 19:51 odesílatel Rob Sargent <robjsarg...@gmail.com> napsal:
> > > 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) > > > you are missing SELECT keyword (2023-09-25 20:05:08) postgres=# select pg_database_size('postgres'); ┌──────────────────┐ │ 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 > > >
