SAGA 9.4.2 | Tool Library Documentation

Import Table from Query


Description

Import a SQL table from a PostgreSQL database.


Parameters

 NameTypeIdentifierDescriptionConstraints
OutputQuery Resulttable, outputTABLE--
OptionsHosttext, CMDPG_HOST-Default: 127.0.0.1
Portinteger number, CMDPG_PORT-Minimum: 0 Default: 5432
Databasetext, CMDPG_DB--
Usertext, CMDPG_USER--
Passwordtext, CMDPG_PWD--
TablestextTABLES--
FieldstextFIELDS--
WheretextWHERE--
Group bytextGROUP--
HavingtextHAVING--
Order bytextORDER--
DistinctbooleanDISTINCT-Default: 0

Command Line


Usage: saga_cmd db_pgsql 15 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-TABLE ] [-TABLES ] [-FIELDS ] [-WHERE ] [-GROUP ] [-HAVING ] [-ORDER ] [-DISTINCT ]
  -PG_HOST: 	Host
	text, CMD
	Default: 127.0.0.1
  -PG_PORT: 	Port
	integer number, CMD
	Minimum: 0
	Default: 5432
  -PG_DB:   	Database
	text, CMD
  -PG_USER: 	User
	text, CMD
  -PG_PWD:  	Password
	text, CMD
  -TABLE:   	Query Result
	table, output
  -TABLES:  	Tables
	text
  -FIELDS:  	Fields
	text
  -WHERE:   	Where
	text
  -GROUP:   	Group by
	text
  -HAVING:  	Having
	text
  -ORDER:   	Order by
	text
  -DISTINCT:	Distinct
	boolean
	Default: 0