Re: generating dynamic queries using pl/pgsql

On Jan 20, 2005, at 12:40 PM, sarlav kumar wrote:

> >Yes, it's possible.
>
> >http://www.postgresql.org/docs/7.4/interactive/plpgsql-
> statements.html#PLPGSQL->STATEMENTS-EXECUTING-DYN
> >The manual has some great information.
>  
> I read through the manual. But I am still not clear how to actually
> generate the "queries" dynamically. In my case, some of the
> "select queries" that I want to dynamically generate have joins and
> some of the "select queries" are just from one table.
>

The point of section 37.6.4 (see the manual again) is that you can
build a query from a combination of text and variables. If you have
pieces of your query, you need to build up the full query using the ||
operator (concatenation). Then you can EXECUTE it.

As for "dumping" the table, look at:

http://www.postgresql.org/docs/7.4/interactive/sql-copy.html

You can use COPY to do this.

HTH,
Sean