Skip site navigation (1) Skip section navigation (2)

Graphical query builder resets functions and joins

From: Wouter Boasson <Wouter(dot)Boasson(at)rivm(dot)nl>
To: pgadmin-support(at)postgresql(dot)org
Subject: Graphical query builder resets functions and joins
Date: 2009-09-29 12:51:25
Message-ID: OFFAB38D6A.EF563858-ONC1257640.0044EC26-C1257640.0046A02F@notesmail.rivm.nl (view raw or flat)
Thread:
Lists: pgadmin-support
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

pgadmin-support by date

Next:From: Niklas OlssonDate: 2009-09-29 13:25:17
Subject: Export server list
Previous:From: Arthur Knight HammerDate: 2009-09-29 12:43:11
Subject: Re: How to use pgAdmin 3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group