Monthly Archives: August 2014


FTP I/O from PostgreSQL

PostgreSQL applications at times need to communicate with external servers using FTP. Oracle has the UTL_TCP package that is very useful for PL/SQL applications. PostgreSQL doesn’t have an equivalent package, but it does have something really powerful … the ability to write functions in various scripting languages. PostgreSQL has four languages that are part of [...]

By | August 21st, 2014|Categories: PostgreSQL, tip|Comments Off on FTP I/O from PostgreSQL

Hierarchical Queries using PostgreSQL

One of the major hurdles faced when converting Oracle’s PL/SQL code to any other database is to find the equivalent of START WITH and CONNECT BY PRIOR. This SQL in Oracle provides a very powerful way of writing hierarchical queries, something that comes in really handy when dealing with hierarchical data – this is fairly [...]

By | August 15th, 2014|Categories: PostgreSQL, tip|Comments Off on Hierarchical Queries using PostgreSQL