Module Execute SQL

Execute SQL commands on a connected PostgreSQL source. Separate different commands with a semicolon (';').

Author: O.Conrad (c) 2013
Specification: grid
Menu: Database|PostgreSQL|Tools

Parameters

	Name	Type	Identifier	Description	Constraints
Options	Host	Text	`PG_HOST`	Password	-
	Port	Integer	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	Text	`PG_NAME`	Database Name	-
	User	Text	`PG_USER`	User Name	-
	Password	Text	`PG_PWD`	Password	-
	SQL Statment	Long text	`SQL`	-	Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER); INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1); DROP TABLE myTable1;
	Show Results	Boolean	`OUTPUT`	-	Default: 1
	Stop on Error	Boolean	`STOP`	-	Default: 0

Command-line

Usage: saga_cmd db_pgsql 6 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-SQL <str>] [-OUTPUT <str>] [-STOP <str>]
  -PG_HOST:<str>	Host
	Text
  -PG_PORT:<num>	Port
	Integer
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>	Database
	Text
  -PG_USER:<str>	User
	Text
  -PG_PWD:<str> 	Password
	Text
  -SQL:<str>    	SQL Statment
	Long text
	Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER);
INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1);
DROP TABLE myTable1;

  -OUTPUT:<str> 	Show Results
	Boolean
	Default: 1
  -STOP:<str>   	Stop on Error
	Boolean
	Default: 0