Module Import Table from SQL Query

Import a SQL table from a PostgreSQL database.

Author: O.Conrad (c) 2013
Menu: Database|PostgreSQL|Tables

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Table from SQL Query	Table (output)	`TABLE`	-	-
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	-
	Available Connections	Choice	`CONNECTION`	-	Available Choices: [0] Default: 0
	Tables	Text	`TABLES`	-	-
	Fields	Text	`FIELDS`	-	Default: *
	Where	Text	`WHERE`	-	-
	Group by	Text	`GROUP`	-	-
	Having	Text	`HAVING`	-	-
	Order by	Text	`ORDER`	-	-
	Distinct	Boolean	`DISTINCT`	-	Default: 0

Command-line

Usage: saga_cmd db_pgsql 15 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-TABLE <str>] [-TABLES <str>] [-FIELDS <str>] [-WHERE <str>] [-GROUP <str>] [-HAVING <str>] [-ORDER <str>] [-DISTINCT <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
  -TABLE:<str>   	Table from SQL Query
	Table (output)
  -TABLES:<str>  	Tables
	Text
  -FIELDS:<str>  	Fields
	Text
	Default: *
  -WHERE:<str>   	Where
	Text
  -GROUP:<str>   	Group by
	Text
  -HAVING:<str>  	Having
	Text
  -ORDER:<str>   	Order by
	Text
  -DISTINCT:<str>	Distinct
	Boolean
	Default: 0