[postgis-devel] PostGis Client

[Markus Schaber]

Hi, Joel,

Joel da Silva wrote:

> somebody knows some postgis client that have a  SQL interface allowing the
> user send ad hoc
>  queries to the database server and graphically display the results?
> 
> I have installed some client applications, such as JUMP, QGIS, openmap,
> but none of these tools performs ad hoc queries.

Create an SQL view for your ad-hoc query, and add an appropriate entry
in geometry_columns table for your view. Then every client should be
able to display this view.

If you want to change the query, you can use 'CREATE OR REPLACE' to
modify the view in place.

Markus