Re: Dynamic SQL with pgsql, how to? - Mailing list pgsql-general

From Maximilian Tyrtania
Subject Re: Dynamic SQL with pgsql, how to?
Date
Msg-id BB360E2A-C056-41C5-A2C5-AC909BDE9B6D@byte-employer.de
Whole thread Raw
In response to Re: Dynamic SQL with pgsql, how to?  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: Dynamic SQL with pgsql, how to?
List pgsql-general
Am 03.05.2010 um 23:50 schrieb Andre Lopes:

> Thanks for the reply's,
>
> I need to do a Dynamic SELECT INTO. There is a way of doing it?

Yes. Plpgsql supports this:

EXECUTE command-string [ INTO [STRICT] target ] [ USING expression [, ... ] ];

See http://developer.postgresql.org/pgdocs/postgres/plpgsql-statements.html

Max

Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
Tel.:    ++49/30/48827-952
Mobil: 0152/292 707 36
email: maximilian.tyrtania@byte-employer.de

pgsql-general by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: GeSHi module for Postgresql?
Next
From: AI Rumman
Date:
Subject: PGPOOL II 2.3.3 encryption