My favorites | Sign in
Project Home Downloads Wiki Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
QgisSQL_console  
Updated Aug 13, 2012 by ajuswork...@gmail.com

Syntax of QgisSQL console

Specification of the language for the QgisSQL interpreter Note:

(A) enclose the sentence A | or separation A replace the expression for some expression of kind A [A] A is repeated 0 or 1 times {A} A repeated 0 or times

Create a PostgreSQL connection

CREATE CONNECTION [ AS  < Name > ]
    TYPE POSTGRESQL
    DATABASE  < Data base name >
    USERNAME  < User name >
    PASSWORD  < User password >
    HOST  < Host name or IP >
    SCHEMA  < Schema > 		-- line deprecated
    PORT  < Port >
    CONNECT [ TRUE | FALSE ]

Create MSQLServer connection

CREATE CONNECTION [ AS < Name > ]
    TYPE MSQLSERVER
    DATABASE < Data base name >
    USERNAME < User name >
    PASSWORD < Password >
    HOST < Host name or IP >
    CONNECT [ TRUE | FALSE ]

Create SQLite connection

CREATE CONNECTION [ AS < Name > ]
    TYPE SQLITE
    DATABASE < File name for the database >
    PATH < Path to the file database >
    INTERFACE [ TRUE | FALSE ]
    CONNECT [ TRUE | FALSE ]

Delete connection from tree list and register Disconnect and delete process

DELETE CONNECTION < Connection name >

Establish default interface

SELECT INTERFACE < Connection name >

Delete a query

DELETE QUERY < Query name > ON CONNECTION < Connection name >

Save a query into a existing connection

CREATE QUERY 
"{" 
    < Any query >
"}" 
    AS < Query name >
    TYPE [ ONLY | SIMLE | TOOL ] 
    [ LAYER < Layer name > ]
    [ ON CONNECTION < Connection name > ]

Send a valid query to the connection with given name

DIRECT < Connection name >
"{" 
    < Any SQL valid setence > 
"}"

Migrate table to a database from a select query

CREATE TABLE < New table name >
    FROM 
    "{"
        (
	    DIRECT < Connection name >
	    "{"
	        SELECT < Select query sentence >
	    "}"
	)
	|
	(
	    SELECT [ * | field1 { , field2 } ]
	    FROM LAYER < Layer name >
	)
	|
	(
	    SELECTION FROM LAYER < Layer name >
	)
"}"
ON CONNECTION < Connection name >

Query a table for edit

EDIT < Table name > ON CONNECTION < Connection name >
Powered by Google Project Hosting