Re: [EXT]Re: Accessing system information functions

Thank you. On Sep 25, 2023, at 4:18 AM, Erik Wienhold wrote: External Email On 2023-09-22 17:37 +, Johnson, Bruce E - (bjohnson) wrote: postgres=# pg_database_size(avi); ERROR: syntax error at or near "pg_database_size" LINE 1: pg_database_size(avi); Call functions with SELECT, e.g.: SEL

Re: Accessing system information functions

Hi po 25. 9. 2023 v 19:51 odesílatel Rob Sargent 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 inf

Accessing system information functions

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 funct

Re: Accessing system information functions

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

Re: Accessing system information functions

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

Re: Accessing system information functions

On 2023-09-22 17:37 +, Johnson, Bruce E - (bjohnson) wrote: > postgres=# pg_database_size(avi); > ERROR: syntax error at or near "pg_database_size" > LINE 1: pg_database_size(avi); Call functions with SELECT, e.g.: SELECT pg_database_size('avi'); Also, the database name must be a st