PL/pgSQL is the native stored procedure language for PostgreSQL. It can be used to write user defined functions and triggers. In PostgreSQL 9.0 and later, PL/pgSQL is installed by default and can also be used in anonymous code blocks using the DO statement.
Stats
created |
1 year ago |
viewed |
3 times |
active |
1 year ago |
editors |
1 |
Recent Hot Answers
Is there a good way to run a trigger for each record in a postgres table?Postgres query plan of a UDF invocation written in pgpsql
PostgreSQL procedural languages - differences between PL/pgSQL and SQL
Create index if it does not exist
Trigger: move deleted rows to archive table
more »
Related Tags
postgresql × 40stored-procedures × 12
sql × 8
functions × 5
postgresql-9.1 × 4
triggers × 4
postgresql-9.2 × 3
dynamic-sql × 3
upsert × 2
postgresql-8.4 × 2
partitioning
best-practices
postgresql-8.3
cursors
psql
plsql
performance
bulkcopy
schema
datafile
error-handling
index
record
logs
cte
