CODEWITHSUNDEEP
sqlpostgresqlstored-procedurestriggers
RKh
RKh

Reputation: 14159

Stored procedures and Triggers in PostgreSQL

I never used these two features in PostgreSQL. Which language is used to write stored procedures and triggers in PGSQL? Is it the same that Oracle or SQL Server follows or it is C?

Upvotes: 0

Views: 585

Answers (3)

Majid Azimi
Majid Azimi

Reputation: 5745

if your are working with text data in stored procedures Perl will be very usefull. I myself use PL/PERL.

Upvotes: 0

Kevin Stricker
Kevin Stricker

Reputation: 17388

It's called PL/PgSQL and is similar to others. http://www.postgresql.org/docs/8.1/static/plpgsql.html

You can call C code functions as well.

Upvotes: 1

Nev Stokes
Nev Stokes

Reputation: 9819

Far more common for writing functions is pl/pgsql but you can use C if you really want to.

Upvotes: 2

Related Questions