Need Assistance: Command to display procedures does not work - Mailing list pgsql-general

From Sasmit Utkarsh
Subject Need Assistance: Command to display procedures does not work
Date
Msg-id CAM-5MT3+Gk11krD5cYQv42usQ43aD_p3ZC==a9ZKxH5SQ_N+8A@mail.gmail.com
Whole thread Raw
Responses Re: Need Assistance: Command to display procedures does not work
Re: Need Assistance: Command to display procedures does not work
List pgsql-general
Hi Postgresql Team,

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.

[sutkarsh-a@dxctravel.svcs.entsvcs.com@zuccmshcd2 data-exports]$ psql "host=10.166.18.116 port=5432 dbname=shc_data user=shc_admin password=abc123 sslmode=require"
psql (10.23, server 14.9)
WARNING: psql major version 10, server major version 14.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

shc_data=> \df
ERROR:  column p.proisagg does not exist
LINE 6:   WHEN p.proisagg THEN 'agg'
               ^
HINT:  Perhaps you meant to reference the column "p.prolang".

shc_data=> SELECT 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)


Regards,
Sasmit Utkarsh
+91-7674022625

pgsql-general by date:

Previous
From: Shanti-Dominique
Date:
Subject: Re: Efficient rows filter for array inclusion with gin index
Next
From: Adrian Klaver
Date:
Subject: Re: Need Assistance: Command to display procedures does not work