Thread: dynamic queries in Postgres

Hi,
does anybody know if Postgres supports dynamic queries? I have a DB
with an html interface. I want users to be able to specify on the
fly
which columns they want to see and with what constrains.
Oracle has a package dbms_sql that allows to do something like this.
I
wander if I can do the same in Postgres.
Cheers,
pawel

pawel wrote:

> does anybody know if Postgres supports dynamic queries? I have a DB
> with an html interface. I want users to be able to specify on the
> fly
> which columns they want to see and with what constrains.
> Oracle has a package dbms_sql that allows to do something like this.
> I
> wander if I can do the same in Postgres.

Use PHP (see http://www.php.net/)

-Egon

--
Grüninger Straße 6 · D-70599 Stuttgart
Fon +49 711 45 37 21 · http://www.php.net/
http://www.php.net/manual/ · http://www.php.net/books.php3
Concert Band: http://www.uni-hohenheim.de/~windband/