Re: Accessing system information functions - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Accessing system information functions
Date
Msg-id CAFj8pRC5kyxfkbbiYmA=9jA2gTS6mhD-nXOS77vODG9rsxKU4g@mail.gmail.com
Whole thread Raw
In response to Accessing system information functions  ("Johnson, Bruce E - (bjohnson)" <Johnson@pharmacy.arizona.edu>)
List pgsql-general
Hi

po 25. 9. 2023 v 19:51 odesílatel Rob Sargent <robjsargent@gmail.com> napsal:


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


pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Right version of jdbc
Next
From: shashidhar Reddy
Date:
Subject: Re: Postgres 11.5 not logging all sqls