Thread: Dynamic sql
<div class="post-text"><p>Hi, this is my first on this list.<br /><p>I want to know the basics of dynamic sql especiallyin PostgreSQL. I was googling for a while but have no luck for getting a good described examples. Maybe someonehere could give me some links to the materials from which you where studying this subject.<p>Ok so to be more accurateI am interested in examples of especially PL/SQL (PostgreSQL) code which will demonstrate examples with description:) <br /><p>Best regards<p>Gabe<br /><p></div>
On 2011-09-10, Gabriel Filipiak <gabriel.filipiak@gmail.com> wrote: > --bcaec517adbceea3c804ac90a376 > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, this is my first on this list. > > I want to know the basics of dynamic sql especially in PostgreSQL. I was > googling for a while but have no luck for getting a good described examples. > Maybe someone here could give me some links to the materials from which you > where studying this subject. Usually I go to the manual first. http://www.postgresql.org/docs/9.0/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN some things to consider: use quote_identifier and quote_literal when passing names and values into the sql statements: you can't pass variables in, only their values. -- ⚂⚃ 100% natural