SAGA-GIS Tool Library Documentation (v9.2.0)

Tool Disconnect from PostgreSQL

Disconnect PostgreSQL data source.

Parameters

 NameTypeIdentifierDescriptionConstraints
OptionsHosttext, CMDPG_HOST-Default: 127.0.0.1
Portinteger number, CMDPG_PORT-Minimum: 0
Default: 5432
Databasetext, CMDPG_NAME--
Usertext, CMDPG_USER--
Passwordtext, CMDPG_PWD--
Connectionschoice, GUICONNECTION-Available Choices:
Default: 0
TransactionschoiceTRANSACT-Available Choices:
[0] rollback
[1] commit
Default: 1

Command-line

Usage: saga_cmd db_pgsql 2 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-TRANSACT <str>]
  -PG_HOST:<str> 	Host
	text, CMD
	Default: 127.0.0.1
  -PG_PORT:<num> 	Port
	integer number, CMD
	Minimum: 0
	Default: 5432
  -PG_NAME:<str> 	Database
	text, CMD
  -PG_USER:<str> 	User
	text, CMD
  -PG_PWD:<str>  	Password
	text, CMD
  -TRANSACT:<str>	Transactions
	choice
	Available Choices:
	[0] rollback
	[1] commit
	Default: 1