table=name

Name of the table containing X, Y coordinate values. If this option is selected instead of sql, then you must specify the X and Y column names (if they aren't "X" and "Y").

coordx=X-coord

Column containing the "x" (easting) coordinate value.

coordy=Y-coord

Column containing the "y" (northing) coordinate value.

where=SQLwhereclause

SQL "where" clause which specifies the query criteria to be used in subsetting the database. The information specified in the where option must indicate the column(s) to be used, the operators to be used in the evaluation and the values which the data in the column will be evaluated against.

For example, if you want to select only those records from the table well where the value for depth is either 58 or 75 the following could be entered:

To select all wells in an area where the value for well is between 50 and 120:

To select all wells of depth greater than 75 where the value for owner is not equal to SMITH:

If the database column used as the selection criteria is a character field then the associated value must be placed in single quotes. To determine the data types associated with columns in the currently selected database use the g.column.pg command with the -v flag.

In addition to the operators presented in the examples above a range of relational operators including and, or, etc. are supported. There may be some differences in the relational operators which are supported with different database drivers.

The examples presented above were created using the command line parser. If d.site.pg is being called from a shell script remember to escape quoted strings. The foll0wing example presents a component of a shell script where the database column label has a value of "O'Reilly".