PostgreSQL : SQL Commands : SELECT

Context of the notion in the technology: Document / Topc: PostgreSQL
Document / Topc: SQL Commands
Related Keywords: Postgre SQL SQL Commands SELECT
Help URL: http://www.postgresql.org/docs/8.1/interactive/sql-select.html

Items Related to SELECT

ABORT
ALTER AGGREGATE (ALTER AGGREGATE)
ALTER CONVERSION (ALTER CONVERSION)
ALTER DATABASE (ALTER DATABASE)
ALTER DOMAIN (ALTER DOMAIN)
ALTER FUNCTION (ALTER FUNCTION)
ALTER GROUP (ALTER GROUP)
ALTER INDEX (ALTER INDEX)
ALTER LANGUAGE (ALTER LANGUAGE)
ALTER OPERATOR (ALTER OPERATOR)
ALTER OPERATOR CLASS (ALTER OPERATOR CLASS)
ALTER ROLE (ALTER ROLE)
ALTER SCHEMA (ALTER SCHEMA)
ALTER SEQUENCE (ALTER SEQUENCE)
ALTER TABLE (ALTER TABLE)
ALTER TABLESPACE (ALTER TABLESPACE)
ALTER TRIGGER (ALTER TRIGGER)
ALTER TYPE (ALTER TYPE)
ALTER USER (ALTER USER)
ANALYZE
BEGIN
CHECKPOINT
CLOSE
CLUSTER
COMMENT
COMMIT
COMMIT PREPARED (COMMIT PREPARED)
COPY
CREATE AGGREGATE (CREATE AGGREGATE)
CREATE CAST (CREATE CAST)
CREATE CONSTRAINT TRIGGER (CREATE CONSTRAINT TRIGGER)
CREATE CONVERSION (CREATE CONVERSION)
CREATE DATABASE (CREATE DATABASE)
CREATE DOMAIN (CREATE DOMAIN)
CREATE FUNCTION (CREATE FUNCTION)
CREATE GROUP (CREATE GROUP)
CREATE INDEX (CREATE INDEX)
CREATE LANGUAGE (CREATE LANGUAGE)
CREATE OPERATOR (CREATE OPERATOR)
CREATE OPERATOR CLASS (CREATE OPERATOR CLASS)
CREATE ROLE (CREATE ROLE)
CREATE RULE (CREATE RULE)
CREATE SCHEMA (CREATE SCHEMA)
CREATE SEQUENCE (CREATE SEQUENCE)
CREATE TABLE (CREATE TABLE)
CREATE TABLE AS (CREATE TABLE AS)
CREATE TABLESPACE (CREATE TABLESPACE)
CREATE TRIGGER (CREATE TRIGGER)
CREATE TYPE (CREATE TYPE)
CREATE USER (CREATE USER)
CREATE VIEW (CREATE VIEW)
DEALLOCATE
DECLARE
DELETE
DROP AGGREGATE (DROP AGGREGATE)
DROP CAST (DROP CAST)
DROP CONVERSION (DROP CONVERSION)
DROP DATABASE (DROP DATABASE)
DROP DOMAIN (DROP DOMAIN)
DROP FUNCTION (DROP FUNCTION)
DROP GROUP (DROP GROUP)
DROP INDEX (DROP INDEX)
DROP LANGUAGE (DROP LANGUAGE)
DROP OPERATOR (DROP OPERATOR)
DROP OPERATOR CLASS (DROP OPERATOR CLASS)
DROP ROLE (DROP ROLE)
DROP RULE (DROP RULE)
DROP SCHEMA (DROP SCHEMA)
DROP SEQUENCE (DROP SEQUENCE)
DROP TABLE (DROP TABLE)
DROP TABLESPACE (DROP TABLESPACE)
DROP TRIGGER (DROP TRIGGER)
DROP TYPE (DROP TYPE)
DROP USER (DROP USER)
DROP VIEW (DROP VIEW)
END
EXECUTE
EXPLAIN
FETCH
GRANT
INSERT
LISTEN
LOAD
LOCK
MOVE
NOTIFY
PREPARE
PREPARE TRANSACTION (PREPARE TRANSACTION)
REINDEX
RELEASE SAVEPOINT (RELEASE SAVEPOINT)
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED (ROLLBACK PREPARED)
ROLLBACK TO SAVEPOINT (ROLLBACK TO SAVEPOINT)
SAVEPOINT
SELECT
SELECT INTO (SELECT INTO)
SET
SET CONSTRAINTS (SET CONSTRAINTS)
SET ROLE (SET ROLE)
SET SESSION AUTHORIZATION (SET SESSION AUTHORIZATION)
SET TRANSACTION (SET TRANSACTION)
SHOW
START TRANSACTION (START TRANSACTION)
TRUNCATE
UNLISTEN
UPDATE
VACUUM

Inner Elements of SELECT

SELECT contains following items:

ALL
DISTINCT
FROM
WHERE
GROUP
BY
HAVING
UNION
INTERSECT
EXCEPT
ORDER
ASC
DESC
USING
LIMIT
OFFSET
FOR
UPDATE
SHARE
OF
NOWAIT
ONLY
NATURAL

PostgreSQL is a free object-relational database server (database management system), released under a flexible BSD-style license. It offers an alternative to other open-source database systems (such as MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server. Similar to other open-source projects such as Apache, Linux, and Mediawiki, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.
-- wikipedia.org

Home