Homepage > Man Pages > Category > General Commands
Homepage > Man Pages > Name > D

db.select

man page of db.select

db.select: Selects data from table.

NAME

db.select - Selects data from table.

KEYWORDS

database, attribute table, SQL

SYNOPSIS

db.select db.select help db.select [-cdvt] [table=name] [database=name] [driver=name] [sql=string] [input=name] [fs=character] [vs=character] [nv=string] [--verbose] [--quiet] Flags: -c Do not include column names in output -d Describe query only (don't run it) -v Vertical output (instead of horizontal) -t Only test query, do not execute --verbose Verbose module output --quiet Quiet module output Parameters: table=name Table name database=name Database name Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ driver=name Driver name Options: dbf,odbc,pg,mysql,sqlite,ogr Default: dbf sql=string SQL select statement For example: 'select * from rybniky where kapri = 'hodne' input=name Name of file with sql statement fs=character Output field separator Default: | vs=character Output vertical record separator nv=string Null value indicator
DESCRIPTION
db.select prints result of selection from database based on SQL statement read from input file or from standard input to standard output.
NOTE
If parameters for database connection are already set with db.connect, they are taken as default values and do not need to be spcified each time. Output will be displayed to stdout or can be directed to a file.

EXAMPLES

echo "select * from roads" | db.select or cat file.sql | db.select or db.select input=file.sql Select all from table roads db.select -c driver=odbc database=g51test table=roads input=file.sql > result.csv Select some string attribute, exclude others: echo "SELECT * FROM archsites WHERE str1 <> 'No Name'" | db.select Select some string attribute with ZERO length: echo "SELECT * FROM archsites WHERE str1 IS NULL" | db.select Select coordinates from PostGIS table: echo "SELECT x(geo),y(geo) FROM localizzazione" | db.select

SEE ALSO

GRASS SQL interface, db.connect, db.describe, db.drivers, db.droptable, db.execute, db.login, db.tables

AUTHOR

? Modifications: Radim Blazek, ITC-Irst, Trento, Italy Last changed: $Date: 2010-11-08 00:02:28 +0100 (Mon, 08 Nov 2010) $ Full index (C) 2003-2010 GRASS Development Team DB.SELECT(1)
 
 
 

Copyright © 2011–2018 by topics-of-interest.com . All rights reserved. Hosted by all-inkl.
Contact · Imprint · Privacy

Page generated in 21.24ms.

uhren.name | brieftauben-versteigerung.com | www.daelim-forum.com