How do I edit a function in PSQL

postgresql function psql
some1 picture some1 · May 22, 2016 · Viewed 9.6k times · Source

I created a default function in PGADMIN but the server doesn't have that software.

How can I edit the function using PSQL?

The closest I've seen is 

\df+ function_name

but the output is garbled and not editable.

This will open the function using a default editor.

\ef function_name()

But then when I save it, it saves as this...

"/tmp/psql.edit.20631.sql" in the bin folder,

which doesn't seem correct.

Answer

Peter Eisentraut picture Peter Eisentraut · May 22, 2016

After you edit the function with \ef, you need to enter \g or ; to execute the statement that updates the function.

So it would be

\ef function_name()
[edit away]
\g

Related questions

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

I've got this PL/pgSQL function which must return some users information. CREATE OR REPLACE FUNCTION my_function( user_id integer ) RETURNS TABLE( id integer, firstname character varying, lastname character varying ) AS $$ DECLARE ids character varying; BEGIN ids := ''; --Some …

Read More
How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?

I want to be able to connect to a PostgreSQL database and find all of the functions for a particular schema. My thought was that I could make some query to pg_catalog or information_schema and get a list …

Read More
No function matches the given name and argument types

My function is: CREATE OR REPLACE FUNCTION FnUpdateSalegtab09 ( iacyrid Integer,iRepId Integer,iDrId Integer,ivrid Integer,imode smallint,itrno varchar,itrdate timestamp,iacid Integer,ivrno varchar,iSuppId Integer,icustname varchar,inetamt money,idisrate real,idisamt money,iRoundOff real,ijrmid integer,…

Read More