[GRASS-user] Displaying Results of Attribute Subselects

GRASS GRASS user
1

   The examples on the db.select manual page are simple, either SELECT of a
single column itself, or conditioned with a simple WHERE clause. If
attributes for a sampling location or river reach are stored in multiple,
related tables in a postgres database, can I run complex SELECT statements
that join multiple tables using db.select? If not, and the queries need to
be run externally to GRASS, how would I display maps of the returned rows?

Rich

2

HI,

2011/3/18 Rich Shepard <rshepard@appl-ecosys.com>:

The examples on the db.select manual page are simple, either SELECT of a
single column itself, or conditioned with a simple WHERE clause. If
attributes for a sampling location or river reach are stored in multiple,
related tables in a postgres database, can I run complex SELECT statements
that join multiple tables using db.select? If not, and the queries need to
be run externally to GRASS, how would I display maps of the returned rows?

yes, you can run any select statement which is supported by DB backend
you are using...

Martin

--
Martin Landa <landa.martin gmail.com> * http://geo.fsv.cvut.cz/~landa

3

On Fri, 18 Mar 2011, Martin Landa wrote:

yes, you can run any select statement which is supported by DB backend
you are using...

Hi Martin!

   Whew! Thanks for confirming this.

Rich