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 1rfNDe-00HGSW-NP for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 16:55:47 +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 1rfNDd-00Cbt2-9W for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 16:55:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfNDc-00Cbss-VT for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 16:55:45 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfNDb-001ohF-53 for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 16:55:44 +0000 Received: by mail-pl1-x634.google.com with SMTP id d9443c01a7336-1dca3951ad9so33615205ad.3 for ; Wed, 28 Feb 2024 08:55:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709139341; x=1709744141; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=ZEVyUjIhYuXQvr/nllgE3IuHTq05EsvDPTSblxaSGRA=; b=LlZIJ0TKPlB6R4DeKsSKZNqMPcnhlXbYikP3bDsMB0pjPztum+8Z6MMMI6dFr1biyb FKTMXtO5Ju2kKrHMGGh2Awe3zhxu8lDRATOB7iJe5vL14tZOpVMx15hPkhXkHuCCp0Gi bMJ8ZhqFwSJ9NiHQLYxUzoV+sIST1mLwjhmSMU+j4Rs9KVFoY8XPRpSFOWa12jW7++NX AAN52bEZmk7bZ4C2ZjXIe4LVrIk6w+8q7m3Bmi+WuwsNLNkK9axoco4H529EfZsahA2T HkdrPQSKj7IYsZlHUuwETINJI7jjxtr+WPxSJQLaHDgmc2VFDUrw0l1IKS+6OL3vYdV4 1afg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709139341; x=1709744141; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ZEVyUjIhYuXQvr/nllgE3IuHTq05EsvDPTSblxaSGRA=; b=nZEufyHI2QTqnWi5k/CAuoHg+DHjieWWXwM5dWGqocJ3jr7QOdCuFRy5qx2II3Cajq 0yWquMffYetyl7v0TeFK4EOLNaBTpN69B7rXoYqbqFWUMGZACad+1Dum2qkBbNvf1a7I gRXK3yD0dnn6GBKE/FoZDL9iQ+JfbckIBKx1mccHvOFwKtnc22j4y7QMdmtVuYdRrCdB RrCHjQDNZQAf6DU9nzRkWwUKOlnUQkbixIQd06d0N+ou5/8Qy76N10OKtHd2QpGwQnUS pFIzivVxFMNdY8Xy3CHI7TEUfHGuwyHq+GYt8FJdoFvt6907klcmD7yk/pYQMLQ0kR3u xvTg== X-Gm-Message-State: AOJu0Yx53ZNpkyu0SoZq8iJXqrF6sma5vVQydKx1qeRVqmbCaS11hKbq F/+4UAGrLsIFIT7hR7cT4FprwsJQR5Kb1KmLxK7vEg0rcJti5c8m X-Google-Smtp-Source: AGHT+IHpz/oKifBqHkW3RtfYxjDKhGDJhcJUv9fHT/e78b+FXkvf0v7+rJMS4mFatuHwBNbIrkFIiw== X-Received: by 2002:a17:902:ea11:b0:1dc:a282:2c76 with SMTP id s17-20020a170902ea1100b001dca2822c76mr27618plg.7.1709139341379; Wed, 28 Feb 2024 08:55:41 -0800 (PST) Received: from smtpclient.apple ([155.100.47.2]) by smtp.gmail.com with ESMTPSA id s5-20020a170902b18500b001dbb06b6133sm3484774plr.127.2024.02.28.08.55.29 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 28 Feb 2024 08:55:35 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.15\)) Subject: Re: Need Assistance: Command to display procedures does not work From: Rob Sargent In-Reply-To: Date: Wed, 28 Feb 2024 09:55:23 -0700 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Sasmit Utkarsh X-Mailer: Apple Mail (2.3654.120.0.1.15) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Feb 28, 2024, at 8:53 AM, Sasmit Utkarsh = wrote: >=20 > Hi Postgresql Team, >=20 > Getting error while executing the below \df command to list the = procedures/functions. whereas query gives the appropriate results Please = assist on how to troubleshoot this. >=20 > [sutkarsh-a@dxctravel.svcs.entsvcs.com@zuccmshcd2 data-exports]$ psql = "host=3D10.166.18.116 port=3D5432 dbname=3Dshc_data user=3Dshc_admin = password=3Dabc123 sslmode=3Drequire" > psql (10.23, server 14.9) > WARNING: psql major version 10, server major version 14. > Some psql features might not work. The version difference between your psql client installation and the = server installation is the problem.