store procedure

Started by Nonamealmost 9 years ago2 messagesdocs
Jump to latest
#1Noname
manish.kumar@tamarindservices.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/plpgsql.html
Description:

hello ,I am new to the postgreSql , so i just want to know is it possible to
write a store procedure in postgresql such as mysql. if yes then how .please
suggest me with better answer.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Noname (#1)
Re: store procedure

On 6/16/17 04:52, manish.kumar@tamarindservices.com wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/plpgsql.html
Description:

hello ,I am new to the postgreSql , so i just want to know is it possible to
write a store procedure in postgresql such as mysql. if yes then how .please
suggest me with better answer.

PostgreSQL does not have CREATE PROCEDURE, only CREATE FUNCTION.
However, there might be other differences if you are coming from a
different system.

This is not the right mailing list for this question. See pgsql-general
or pgsql-novice please.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs