SAGA-GIS Tool Library Documentation (v8.5.1)

Tool Import Raster from PostGIS

Imports grids from a PostGIS database.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputGridsGrid list, outputGRIDS--
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
TablesChoiceTABLES-Available Choices:
Default: 0
WhereTextWHERE--
Multiple Bands OutputChoiceMULTIPLE-Available Choices:
[0] single grids
[1] grid collection
[2] automatic
Default: 2

Command-line

Usage: saga_cmd db_pgsql 30 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-GRIDS <str>] [-TABLES <str>] [-WHERE <str>] [-MULTIPLE <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
  -GRIDS:<str>   	Grids
	Grid list, output
  -TABLES:<str>  	Tables
	Choice
	Available Choices:
	Default: 0
  -WHERE:<str>   	Where
	Text
  -MULTIPLE:<str>	Multiple Bands Output
	Choice
	Available Choices:
	[0] single grids
	[1] grid collection
	[2] automatic
	Default: 2