SAGA-GIS Tool Library Documentation (v7.8.2)

Tool Import Shapes with Joined Data from PostGIS (GUI)

Imports shapes with joined data from a PostGIS database.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputShapesShapes, outputSHAPES--
OptionsHostText, CMDPG_HOSTPassword-
PortInteger, CMDPG_PORT-Minimum: 0
Default: 5432
DatabaseText, CMDPG_NAMEDatabase Name-
UserText, CMDPG_USERUser Name-
PasswordText, CMDPG_PWDPassword-
Available ConnectionsChoice, GUICONNECTION-Available Choices:
Default: 0
Geometry TableChoiceGEO_TABLE-Available Choices:
Default: 0
KeyChoiceGEO_KEY-Available Choices:
Default: 0
Join TableChoiceJOIN_TABLE-Available Choices:
Default: 0
KeyChoiceJOIN_KEY-Available Choices:
Default: 0
FieldsParametersFIELDS-0 Parameters:
WhereTextWHERE--

Command-line

Usage: saga_cmd db_pgsql 23 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-SHAPES <str>] [-GEO_TABLE <str>] [-GEO_KEY <str>] [-JOIN_TABLE <str>] [-JOIN_KEY <str>] [-WHERE <str>]
  -PG_HOST:<str>   	Host
	Text, CMD
  -PG_PORT:<num>   	Port
	Integer, CMD
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>   	Database
	Text, CMD
  -PG_USER:<str>   	User
	Text, CMD
  -PG_PWD:<str>    	Password
	Text, CMD
  -SHAPES:<str>    	Shapes
	Shapes, output
  -GEO_TABLE:<str> 	Geometry Table
	Choice
	Available Choices:
	Default: 0
  -GEO_KEY:<str>   	Key
	Choice
	Available Choices:
	Default: 0
  -JOIN_TABLE:<str>	Join Table
	Choice
	Available Choices:
	Default: 0
  -JOIN_KEY:<str>  	Key
	Choice
	Available Choices:
	Default: 0
  -WHERE:<str>     	Where
	Text