From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
Cc: | "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Accessing system information functions |
Date: | 2023-09-25 18:05:58 |
Message-ID: | CAFj8pRC5kyxfkbbiYmA=9jA2gTS6mhD-nXOS77vODG9rsxKU4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
po 25. 9. 2023 v 19:51 odesílatel Rob Sargent <robjsargent(at)gmail(dot)com>
napsal:
>
>
> On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) <
> Johnson(at)pharmacy(dot)arizona(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | shashidhar Reddy | 2023-09-25 18:55:54 | Re: Postgres 11.5 not logging all sqls |
Previous Message | Dave Cramer | 2023-09-25 16:42:51 | Re: Right version of jdbc |