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 >