How to \ef a function ?

From: David Gauthier <dfgpostgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to \ef a function ?
Date: 2024-01-08 16:26:57
Message-ID: CAEs=6D=nwX2wm0hjkaw6C_LnqR+NFtnnzbSzeZq-xcfi_ooKSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

atletx7-reg017:/home/dgauthie[ 120 ] --> dvdbdev
Pager usage is off.
psql (11.5, server 11.3)
Type "help" for help.

dvdb=# \df opid.bef_ins_axi_reqs_set_trig;
List of functions
Schema | Name | Result data type | Argument data
types | Type
--------+---------------------------+------------------+---------------------+------
opid | bef_ins_axi_reqs_set_trig | trigger |
| func
(1 row)

dvdb=# \ef opid.bef_ins_axi_reqs_set_trig;
ERROR: function "opid.bef_ins_axi_reqs_set_trig;" does not exist
dvdb=# \ef opid.bef_ins_axi_reqs_set_trig();
ERROR: expected a right parenthesis
dvdb=#

So the function exists with \df but not \ef ?
I get the need to identify the argument list (in case there's >1 with same
name, diff arg list), but '()' doesn't work. Does this have to do with the
returned trigger type ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-01-08 16:40:14 Re: How to \ef a function ?
Previous Message Carlos Augusto Ferreira de Oliveira 2024-01-08 11:23:59 Point-In-Time Recovery issue - Timeline file lost