Import Table from SQL Query

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

Description

Import a SQL table from a PostgreSQL database.

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Query Result	table, output	`TABLE`	-	-
Options	Connection	choice	`CONNECTION`	-	Available Choices: Default: 0
	Tables	text	`TABLES`	-	-
	Fields	text	`FIELDS`	-	-
	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 [-CONNECTION ] [-TABLE ] [-TABLES ] [-FIELDS ] [-WHERE ] [-GROUP ] [-HAVING ] [-ORDER ] [-DISTINCT ]
  -CONNECTION:	Connection
	choice
	Available Choices:
	Default: 0
  -TABLE:     	Query Result
	table, output
  -TABLES:    	Tables
	text
  -FIELDS:    	Fields
	text
  -WHERE:     	Where
	text
  -GROUP:     	Group by
	text
  -HAVING:    	Having
	text
  -ORDER:     	Order by
	text
  -DISTINCT:  	Distinct
	boolean
	Default: 0