The syntax for Hyperstage SQL commands is exactly the same as the syntax for PostgreSQL commands. For more information, see the PostgreSQL 9.2 Documentation.

There are special considerations when using the following commands with Hyperstage. All other SQL commands can be used with Hyperstage as they are with the standard PostgreSQL.

Using PostgreSQL Commands With Hyperstage
PostgreSQL Command	More Information
CREATE TABLE, DROP TABLE	Creating and Dropping Tables.
SHOW TABLE STATUS, SHOW FULL COLUMNS	Viewing Compression Ratio Statistics.
INSERT, UPDATE, DELETE	Data Manipulation Statements.
LOAD DATA INFILE	Importing and Exporting Data in Hyperstage.
SELECT	Running Queries in Hyperstage.
VIEW	Creating VIEWs in Hyperstage.