pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Sargent <robjsargent@gmail.com>
To: Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Accessing system information functions
Date: Mon, 25 Sep 2023 06:31:27 -0600
Message-ID: <F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com> (raw)
In-Reply-To: <5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu>
References: <5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu>


--Apple-Mail-B833652C-BCFB-4FF8-B113-7586E593F768
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br=
></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Sep 25, 2023, at 5:=
05 AM, Johnson, Bruce E - (bjohnson) &lt;Johnson@pharmacy.arizona.edu&gt; wr=
ote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=
=BB=BF

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8">


Environment: Ubuntu 22.04 lts, postgres 15 installed via <a href=3D"http://p=
ostgres.org">
postgres.org</a>&nbsp;repository
<div><br>
</div>
<div>I am attempting to use the system information functions here:&nbsp;<a h=
ref=3D"https://www.postgresql.org/docs/15/functions-info.html">https://www.p=
ostgresql.org/docs/15/functions-info.html</a></div>
<div><br>
</div>
<div>I=E2=80=99m logged on as the postgres superuser on the host</div>
<div><br>
</div>
<div>Trying any of the functions gives me a syntax error</div>
<div><br>
</div>
<div>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">postgres=3D# pg_=
database_size(avi);</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">ERROR:&nbsp; syn=
tax error at or near "pg_database_size"</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">LINE 1: pg_datab=
ase_size(avi);</span></p>
</div>
<div>&nbsp;</div>
<div>Do I have to add anything to the search_path?</div>
<div><br>
</div>
<div>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">postgres=3D# sho=
w search_path;</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">&nbsp;&nbsp; sea=
rch_path&nbsp; &nbsp;</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">----------------=
-</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">&nbsp;"$user", p=
ublic</span></p>
<p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; font=
-stretch: normal; font-size: 18px; line-height: normal; font-family: Consola=
s; font-size-adjust: none; font-kerning: auto; font-variant-alternates: norm=
al; font-variant-ligatures: normal; font-variant-numeric: normal; font-varia=
nt-east-asian: normal; font-variant-position: normal; font-feature-settings:=
 normal; font-optical-sizing: auto; font-variation-settings: normal; backgro=
und-color: rgb(225, 225, 225);">
<span style=3D"font-variant-ligatures: no-common-ligatures">(1 row)</span></=
p>
</div>
<div><span style=3D"font-variant-ligatures: no-common-ligatures"><br>
</span></div>
<div><br>
</div>
<div><br></div></div></blockquote><div><br></div>And single quote name. 'avi=
'<br><blockquote type=3D"cite"><div dir=3D"ltr"><div>
<div>--&nbsp;<br>
Bruce Johnson<br>
University of Arizona<br>
College of Pharmacy<br>
Information Technology&nbsp;Group<br>
<br>
Institutions do not&nbsp;have opinions, merely&nbsp;customs<br>
<br>
</div>
<br>
</div>


</div></blockquote></body></html>=

--Apple-Mail-B833652C-BCFB-4FF8-B113-7586E593F768--





view thread (6+ messages)  latest in thread

Message-ID: <F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com>
Permalink:  ../F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com/
Also on:    postgresql.org/message-id/F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: robjsargent@gmail.com, Johnson@pharmacy.arizona.edu
  Subject: Re: Accessing system information functions
  In-Reply-To: <F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com>
  References: <5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu> <F902B1CC-9AC5-4090-AFFA-DE737CF12262@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox