Applies to PgAdmin 1.10.0, PostGIS (in general) When working with geodata (using PostGIS in PostgreSQL) its often neccessary to make joins that are not regular joins (see the example below), and use all kinds of special processing functions. It is not possible to enter them in the graphical query builder which would be a great enhancement.
The real problem is that, when entering the SQL manually using functions, and you switch to the graphical query builder, it can't handle this and crashes. Or it doesn't crash, but when returning to the SQL-editor tab the information entered manually is lost. I hope that this can be solved! Example function in the "SELECT" clause: SELECT zipcode, ST_PointOnSurface(shape) This could be part of a "WHERE" clause to join two tables spatially: ST_Intersects(nl.adm_pc4_2009.shape, nl.adm_gem_2008_lw.shape) Furthermore, the query builder should be able to deal with grouping etc. Regards, Wouter Disclaimer RIVM