3 ms·
In Postgres you were never really restricted to SQL, there's built-in support for Tcl, Perl and Python, and third-party support for others. https://www.postgre
by icebraining 10y ago
In Postgres you were never really restricted to SQL, there's built-in support for Tcl, Perl and Python, and third-party support for others.
https://www.postgresql.org/docs/9.5/static/xplang.html https://www.postgresql.org/docs/9.5/static/xplang.html
- bdcravens 10y agoArticle acknowledges this: "There are currently several language implementations for Postgres, including PL/SQL (similar to SQL/PSM), Python and Perl. The aim of this project is to add Andl to that list, but as more than ‘just another language’."
- sk5t 10y agoFYI, the name PL/SQL traditionally refers to Oracle's thing... Postgres has PL/pgSQL.
- cmdkeen 10y agoI did a double take at that. My heart skipped a beat thinking I could maybe suggest porting some old Oracle stuff over to Postgres. A quick Google shattered my dreams. Damn you article.
- tkyjonathan 10y agoYou can actually. If you want more out of the box tools to migrate from Oracle, then look at EnterpriseDB.