Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkki5-00GDEH-Fu for pgsql-general@arkaria.postgresql.org; Mon, 25 Sep 2023 12:29:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qkki3-0012eK-S3 for pgsql-general@arkaria.postgresql.org; Mon, 25 Sep 2023 12:29:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkki3-0012e2-Bu for pgsql-general@lists.postgresql.org; Mon, 25 Sep 2023 12:29:07 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qkki0-006YCf-S5 for pgsql-general@lists.postgresql.org; Mon, 25 Sep 2023 12:29:06 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-3ab2436b57dso4232479b6e.0 for ; Mon, 25 Sep 2023 05:29:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695644943; x=1696249743; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=dGN/2QCi37Adzz2Q+A9yPnnBzzRzuSclkbZhZ7ijEC0=; b=ZnciHJVnaHdvFH5VBvJwghHdOBU3FSvYP+bPDoC4/BYg01doS4w4hKMZ0xN9LaoNo6 Uqp0t66xay/xmwzUu6pvD0WW9bMQBcnPYx40G4qeKmi9ZTGXSZ++F9hmIH9HOEob6h9/ s7Jcpy48eJt36XjDfXxlzKIeCttz4TJG5EHszEBW0E/UrtoDb+ahARuHexbbDevTJyYm /8vHVno7BkepKmArG0r2O+9xtJ0XYSzo8pSUOBbWNQQQ5pCrgg9bLLIsTGEAIx8uFylE ZE0Eji6cmP2qdSuFR6RtlUpPtkQ3nCiPMvOjWTOVkhz9TVYtklJ3/MyDoRnAzdFD0v+n +pIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695644943; x=1696249743; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=dGN/2QCi37Adzz2Q+A9yPnnBzzRzuSclkbZhZ7ijEC0=; b=t/QsgcbC1H4WG+JRqecpG0cVCcvqhOxAGFRsF+iZf43W63W5T9o/p4Jq1epyowDQ9S ZdiThSJZqytGQVGf6fVpxemaLL1RYO1EUzh6XrALineRTmErgNykMY8rfMRtPPTMPJce vGTi1IOy4CWytDTYQ/2z8+DZ2PO5SZvp3c3c546m+dqQPmuJZgZHkAGN3XvD7fH+t+Fg PJ8gnuWiRm1UIDkm2Sa2swShl7lid0KlWNQBddbDsZ13OS1FeAHiirL4EqS4IIfjjXL+ uFGWei3sLQfwEHDY9xPDamDPFxUla78SKXJMS4hwSOG20tRsREACS+2H3PR812CzSgUz jOoQ== X-Gm-Message-State: AOJu0Yy2xGvgSflaZPwB1tQnKpbJ7HVRiNkvBDmdUiY9jv1n1Ox9cTqj OFcXoyB56lyjDXxEftDZh5gfvIvJrDk= X-Google-Smtp-Source: AGHT+IHu4lkX9pale6X2IZC9j6w5YdemS0Q5dUbOXZbgPR080b1yx7E46KgtlyOith169MRh5ESQlg== X-Received: by 2002:a05:6808:1304:b0:3a7:b094:8f2 with SMTP id y4-20020a056808130400b003a7b09408f2mr10685343oiv.45.1695644943357; Mon, 25 Sep 2023 05:29:03 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5a00:f790:adbc:f1f8:568d:b91d]) by smtp.gmail.com with ESMTPSA id r9-20020a63a009000000b0057e13ed796esm4976662pge.60.2023.09.25.05.29.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 25 Sep 2023 05:29:02 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-D5E1F70A-7024-466A-B987-99BBE242070A Content-Transfer-Encoding: 7bit From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Accessing system information functions Date: Mon, 25 Sep 2023 06:28:52 -0600 Message-Id: <9F887C2A-4715-4BCA-8ACF-8ECEB87E450D@gmail.com> References: <5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu> Cc: pgsql-general@lists.postgresql.org In-Reply-To: <5B326637-1E35-4E23-ACAF-24CF106E8621@arizona.edu> To: "Johnson, Bruce E - (bjohnson)" X-Mailer: iPhone Mail (20G81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-D5E1F70A-7024-466A-B987-99BBE242070A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

On Sep 25, 2023, at 5:= 05 AM, Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu> wr= ote:

=EF= =BB=BF Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org repository

I am attempting to use the system information functions here: https://www.p= ostgresql.org/docs/15/functions-info.html

I=E2=80=99m logged on as the postgres superuser on the host

Trying any of the functions gives me a syntax error

postgres=3D# pg_= database_size(avi);

ERROR:  syn= tax error at or near "pg_database_size"

LINE 1: pg_datab= ase_size(avi);

 
Do I have to add anything to the search_path?

postgres=3D# sho= w search_path;

   sea= rch_path   

----------------= -

 "$user", p= ublic

(1 row)





Select pg_database_size(avi= );


= --Apple-Mail-D5E1F70A-7024-466A-B987-99BBE242070A--