SAGA 9.4.2 | Tool Library Documentation

Disconnect from PostgreSQL


Description

Disconnect PostgreSQL data source.


Parameters

 NameTypeIdentifierDescriptionConstraints
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--
TransactionschoiceTRANSACT-Available Choices: [0] rollback [1] commit Default: 1

Command Line


Usage: saga_cmd db_pgsql 2 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-TRANSACT ]
  -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
  -TRANSACT:	Transactions
	choice
	Available Choices:
	[0] rollback
	[1] commit
	Default: 1