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 1rfNNb-00HHOx-D1 for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 17:06:04 +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 1rfNNZ-00ClJy-Ts for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 17:06:02 +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 1rfNNZ-00ClJp-Iw for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 17:06:02 +0000 Received: from wfout3-smtp.messagingengine.com ([64.147.123.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfNNV-001old-O4 for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 17:06:01 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailfout.west.internal (Postfix) with ESMTP id B86E61C0008F; Wed, 28 Feb 2024 12:05:54 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Wed, 28 Feb 2024 12:05:54 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1709139954; x=1709226354; bh=A7QpPh2MubcBICO7Je9TlTJP9rNQ4A6KSV02/YAH428=; b= YM1HZtEll13zBXnMyjskQzIWKHXD6WcQBMXgN8N8UJp9n26bF1X/gfLeHnNo/pa3 dMJbpLWJEUt1TiMR4APHdPeOYsZ7fW2VxvYd0py/A4zUe04B0kM57ks2JNwYYPmw W3cNa4tJSjIa2BQC8u2s/AK26yVaa4wjsa4WjOLQrFriJZde8Wj8LOzqYZWk68cF ZJq3jAd+sklBNb1GBMSCsjp79tmJdFhBunFUS9vKFo4LF0TqCVHf8PuztC84ft9Y FR2ALesvGawSVHhHGANpbHoUYba4pmteMbDS6zxgLGUAlhXI1kYjsp4fJD7MyRE8 YlwkauvyFSC5tfJmkh/wFg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1709139954; x= 1709226354; bh=A7QpPh2MubcBICO7Je9TlTJP9rNQ4A6KSV02/YAH428=; b=E v54oeVwdjWSFr7RimjnJCI2AC44sY1ktby9xOFoLlns9T99vVJyluRrN5WEDByFt Zb/ABekM1nYwaM2rRnXlBIkcOAN/1MsokNN4hvrlRGL4scnDGZpd4wLrR5U/IJ6Y zD87tuFXOOHt3GZWXgIa1TbPx7Q0l158UvLzZ7V2zrfB3Idg5IMWAcj4m5KFHgpC VtiA4t7yU0CfvTp9QGwK9CWHQX0X1MMSoNI2fZK0qucmeBgHE7NuFwqP1ZlOnj18 eHXZbqaZTQM4Fq5L1/w5GaKSXlKYZAhAS3jaVko9k2PDVsHBIXunMlO94CjhejAZ oZjuth6JFaB/TZe6na33Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrgeejgdelvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeefgeefieeutdfggfetgefgheekjeehteeileeigfet ieekjedvieeviefgheevtdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 28 Feb 2024 12:05:53 -0500 (EST) Message-ID: <665d481a-fdb2-44c2-8809-eae871d1b947@aklaver.com> Date: Wed, 28 Feb 2024 09:05:53 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Need Assistance: Command to display procedures does not work Content-Language: en-US To: Sasmit Utkarsh Cc: pgsql-general@lists.postgresql.org References: <545a6cd8-aa5b-45aa-8621-158ea355a09a@aklaver.com> From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/28/24 08:52, Sasmit Utkarsh wrote: > Hi Adrian, > > Thanks for the info, But I have another question: I could see the below > functions list with the help on query execution on psql command line > >   shc_data=> S*ELECT proname AS function_name,proacl AS privileges FROM > pg_proc WHERE proname in > ('sql_insert_data_procedure','sql_select_data_procedure','sql_select_size_procedure','sql_update_data_procedure');* >        function_name       | privileges > ---------------------------+------------ >  sql_select_size_procedure | >  sql_select_data_procedure | >  sql_insert_data_procedure | >  sql_update_data_procedure | > (4 rows) > > but when I try to connect to the same db on PgAdmin4, I don't see the > list even after refresh. Why is that different? 1) Are you sure you are connecting to correct database. 2) If I followed your previous posts correctly those functions where not in the public schema you are looking at in pgAdmin4. They where in the shc(?) schema which I am pretty sure is the second schema in the Schemas(2) in the object tree. > Thet > image.png > > > > > > Regards, > Sasmit Utkarsh > +91-7674022625 > > -- Adrian Klaver adrian.klaver@aklaver.com