From: | "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: [EXT]Re: Accessing system information functions |
Date: | 2023-09-25 15:50:45 |
Message-ID: | EB102B9D-8CBC-4E6D-9BEF-A7CC3B523C97@arizona.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you.
On Sep 25, 2023, at 4:18 AM, Erik Wienhold <ewie(at)ewie(dot)name> wrote:
External Email
On 2023-09-22 17:37 +0000, 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 string.
Do I have to add anything to the search_path?
Not for objects in schema pg_catalog which is always searched whether
it's listed in the search path or not.
--
Erik
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2023-09-25 16:03:28 | Re: Right version of jdbc |
Previous Message | Brad White | 2023-09-25 14:42:16 | Move from v9.4 to v15 |