How to compile procedure in postgres

Question

Is there any alternative in postgres to compile procedure as oracle? I searched ,but couldn't find any relevant alternatives for it . Can anyone suggest on this?

alter procedure proc_name compile. in oracle

equivalent to postgres.

There is no such thing in Postgres. What problem are you trying to solve with that? — user330315
– user330315, Commented Feb 18, 2022 at 7:54
Procedures written in C must be compiled, but outside of PostgreSQL and loaded afterwards. postgresql.org/docs/current/xfunc-c.html#DFUNC — Frank Heikens
– Frank Heikens, Commented Feb 18, 2022 at 8:22

Laurenz Albe · Accepted Answer · 2022-02-18 08:31:26Z

6

User-defined functions are interpreted in PostgreSQL, so there is no need to compile them. The function code is stored as a string, and a procedural language handler executes it when the function is called. This may of course lead to some kind of on-the-fly compilation process, but this is dependent on the procedural language being used.

PL/pgSQL does not compile anything (but it caches the plans of static SQL statements executed in the function).

answered Feb 18, 2022 at 8:31

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compile procedure in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related