SAGA-GIS Module Library Documentation (v2.2.2)

Module Import Table from SQL Query

Import a SQL table from a PostgreSQL database.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputTable from SQL QueryTable (output)TABLE--
OptionsHostTextPG_HOSTPassword-
PortIntegerPG_PORT-Minimum: 0
Default: 5432
DatabaseTextPG_NAMEDatabase Name-
UserTextPG_USERUser Name-
PasswordTextPG_PWDPassword-
Available ConnectionsChoiceCONNECTION-Available Choices:
[0]
Default: 0
TablesTextTABLES--
FieldsTextFIELDS-Default: *
WhereTextWHERE--
Group byTextGROUP--
HavingTextHAVING--
Order byTextORDER--
DistinctBooleanDISTINCT-Default: 0

Command-line

Usage: saga_cmd db_pgsql 15 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-TABLE <str>] [-TABLES <str>] [-FIELDS <str>] [-WHERE <str>] [-GROUP <str>] [-HAVING <str>] [-ORDER <str>] [-DISTINCT <str>]
  -PG_HOST:<str> 	Host
	Text
  -PG_PORT:<num> 	Port
	Integer
	Minimum: 0
	Default: 5432
  -PG_NAME:<str> 	Database
	Text
  -PG_USER:<str> 	User
	Text
  -PG_PWD:<str>  	Password
	Text
  -TABLE:<str>   	Table from SQL Query
	Table (output)
  -TABLES:<str>  	Tables
	Text
  -FIELDS:<str>  	Fields
	Text
	Default: *
  -WHERE:<str>   	Where
	Text
  -GROUP:<str>   	Group by
	Text
  -HAVING:<str>  	Having
	Text
  -ORDER:<str>   	Order by
	Text
  -DISTINCT:<str>	Distinct
	Boolean
	Default: 0