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 1qkkka-00GDgu-GJ for pgsql-general@arkaria.postgresql.org; Mon, 25 Sep 2023 12:31:44 +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 1qkkkY-0015NJ-TG for pgsql-general@arkaria.postgresql.org; Mon, 25 Sep 2023 12:31:42 +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 1qkkkY-0015My-Bq for pgsql-general@lists.postgresql.org; Mon, 25 Sep 2023 12:31:42 +0000 Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qkkkV-006YDL-QT for pgsql-general@lists.postgresql.org; Mon, 25 Sep 2023 12:31:41 +0000 Received: by mail-pl1-x62f.google.com with SMTP id d9443c01a7336-1c5c91bec75so41520595ad.3 for ; Mon, 25 Sep 2023 05:31:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695645098; x=1696249898; 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=LThkumo2SHznJHFdsRZVR5vIAPwZNX/9O39RuNanbWY=; b=GMIyqTPZLaodCabcAZDXOm+ucaAGl6RrdYep6Y6icKK7s9/zIwv7R/yNL1RcpWGQ3d QEBEPYyEYd5SKjiKEHLHyDPSwwKry8Gi3G3yTjyPc44Ci5bVJu+2ljIwXP20D1xDE6nD CHlIO1hL95bKBwoX77gqJh0CebpA31PG690kApd4OKNEJTH+UjiOOeT+tswDlqyOPRUu jlBrtn94eHmjsL73wrjPqpl9F2V1sfP4eE7SjQrLtSGca5GfE7IkY/y8i2ZX4ZMO2Wz8 Tb5Vh45/IFwFVCLQObyIzm6ethwkXbiIuSVJcvhRJm3wuK0ixx73O6IvR7SZcGIEyJya Zzeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695645098; x=1696249898; 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=LThkumo2SHznJHFdsRZVR5vIAPwZNX/9O39RuNanbWY=; b=U3RR28TXzIXheu//Pyv+dYHvxtaFlTT7o+w1Jd37ucwejQ1ET6VadsWtl1PMdT8+E/ yZ0pcBergf0gKQjxcA1Sh4Gno0K33a++G0eBCOiiRsZkrLTSHPsfwTqRb02bjeXsvnmH TlZedF6e5ZVMQn+sRjjiPGQhpsICD8DEfczc1YfL4OjGrFIAoA3it7GFvI/CdeO8wCy6 AWPxebMaXl/MjFsfy0VbFC12/SYWyjcZCu9KPk2bLlmFkV2KuNyOMCBbwytVQRxdJWlF h7ucpfmGrKpRmaH3T4CRVXKUZzWZbChMbd5vo4jAdkVoK1s4fZmmT/iHiQ4lzygFFOM+ ETmg== X-Gm-Message-State: AOJu0YzG2R86+KV7iwY1cg/3Vu6ntiukm8SB952F1HvwIAzfIha+pfPs /tlzC0/1rRmCnjRpfdrgIzeBg8jsBmk= X-Google-Smtp-Source: AGHT+IEr4NYyMbqL35za6nyult1jcqWikzhUsCQU+INO7b90kTVBagkBIWvy/6YABvAUVFzeJrXrLQ== X-Received: by 2002:a17:902:d482:b0:1c1:e52e:49e3 with SMTP id c2-20020a170902d48200b001c1e52e49e3mr5436094plg.36.1695645098527; Mon, 25 Sep 2023 05:31:38 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5a00:f790:adbc:f1f8:568d:b91d]) by smtp.gmail.com with ESMTPSA id b17-20020a170902ed1100b001c6187f2875sm2354769pld.225.2023.09.25.05.31.37 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 25 Sep 2023 05:31:38 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-B833652C-BCFB-4FF8-B113-7586E593F768 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:31:27 -0600 Message-Id: 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-B833652C-BCFB-4FF8-B113-7586E593F768 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)





And single quote name. 'avi= '
-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs


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