Home |  Products |  Services |  Contact |  Buy
Home :: PostgreSQL				Search
Package   Features   Benefits and Advantages   Supported Platforms   Target Audience   Licensing Policy   Buy   Register		SQL Syntax   PostgreSQL is a Relational Database Management System that also has Object-relational extensions, combining the best features of both an object-oriented database (OODB) and a relational database management system (RDBMS). It supports the same commands and syntax widely used by relational databases throughout the industry. This allows Structured Query Language (SQL) code written on other platforms to run on PostgreSQL with little or no modification. Similarly, since the SQL grammar conforms to the 1992 standard, database programmers knowing SQL can readily become productive in PostgreSQL.   Basic SQL Commands: ABORT Aborts the current transaction ALTER TABLE Modifies table properties ALTER USER Modifies user account information BEGIN Begins a transaction in chained mode CLOSE Close a cursor CLUSTER Gives storage clustering advice to the backend COMMIT Commits the current transaction COPY Copies data between files and tables CREATE AGGREGATE Defines a new aggregate function CREATE DATABASE Creates a new database CREATE FUNCTION Defines a new function CREATE INDEX Constructs a secondary index CREATE LANGUAGE Defines a new language for functions CREATE OPERATOR Defines a new user operator CREATE RULE Defines a new rule CREATE SEQUENCE Creates a new sequence number generator CREATE TABLE Creates a new table CREATE TABLE AS Creates a new table CREATE TRIGGER Creates a new trigger CREATE TYPE Defines a new base data type CREATE USER Creates account information for a new user CREATE VIEW Constructs a virtual table DECLARE Defines a cursor for table access DELETE Deletes rows from a table DROP AGGREGATE Removes the definition of an aggregate function DROP DATABASE Destroys an existing database DROP FUNCTION Removes a user-defined C function DROP INDEX Removes an index from a database DROP LANGUAGE Removes a user-defined procedural language DROP OPERATOR Removes an operator from the database DROP RULE Removes an existing rule from the database DROP SEQUENCE Removes an existing sequence DROP TABLE Removes existing tables from a database DROP TRIGGER Removes the definition of a trigger DROP TYPE Removes a user-defined type from the system catalogs DROP USER Removes an user account information DROP VIEW Removes an existing view from a database EXPLAIN Shows statement execution details FETCH Gets rows using a cursor GRANT Grants access privilege to a user, a group or all users INSERT Inserts new rows into a table LISTEN Listen for notification on a notify condition LOAD Dynamically loads an object file LOCK Explicit lock of a table inside a transaction MOVE Moves cursor position NOTIFY Signals all frontends and backends listening on a notify condition RESET Restores run-time parameters for session to default values REVOKE Revokes access privilege from a user, a group or all users. ROLLBACK Aborts the current transaction SELECT Retrieve rows from a table or view. SELECT INTO Create a new table from an existing table or view SET Set run-time parameters for session SHOW Shows run-time parameters for session UNLISTEN Stop listening for notification UPDATE Replaces values of columns in a table VACUUM Clean and analyze a Postgres database		Technical Information Inheritance SQL Syntax Data Integrity Data Types Functions Programming Languages
		info@dbexperts.net