首页 > 代码库 > postgresql的SQL命令

postgresql的SQL命令

db=# \help
可用的说明:
   ABORT
  ALTER AGGREGATE
  ALTER COLLATION
  ALTER CONVERSION
  ALTER DATABASE
  ALTER DEFAULT PRIVILEGES
  ALTER DOMAIN
  ALTER EVENT TRIGGER
  ALTER EXTENSION
  ALTER FOREIGN DATA WRAPPER
  ALTER FOREIGN TABLE
  ALTER FUNCTION
  ALTER GROUP
  ALTER INDEX
  ALTER LANGUAGE
  ALTER LARGE OBJECT
  ALTER MATERIALIZED VIEW
  ALTER OPERATOR
  ALTER OPERATOR CLASS
  ALTER OPERATOR FAMILY
  ALTER ROLE
  ALTER RULE
  ALTER SCHEMA
  ALTER SEQUENCE
  ALTER SERVER
  ALTER TABLE
  ALTER TABLESPACE
  ALTER TEXT SEARCH CONFIGURATION
  ALTER TEXT SEARCH DICTIONARY
  ALTER TEXT SEARCH PARSER
  ALTER TEXT SEARCH TEMPLATE
  ALTER TRIGGER
  ALTER TYPE
  ALTER USER
  ALTER USER MAPPING
  ALTER VIEW
  ANALYZE
  BEGIN
  CHECKPOINT
  CLOSE
  CLUSTER
  COMMENT
  COMMIT
  COMMIT PREPARED
  COPY
  CREATE AGGREGATE
  CREATE CAST
  CREATE COLLATION
  CREATE CONVERSION
  CREATE DATABASE
  CREATE DOMAIN
  CREATE EVENT TRIGGER
  CREATE EXTENSION
  CREATE FOREIGN DATA WRAPPER
  CREATE FOREIGN TABLE
  CREATE FUNCTION
  CREATE GROUP
  CREATE INDEX
  CREATE LANGUAGE
  CREATE MATERIALIZED VIEW
  CREATE OPERATOR
  CREATE OPERATOR CLASS
  CREATE OPERATOR FAMILY
  CREATE ROLE
  CREATE RULE
  CREATE SCHEMA
  CREATE SEQUENCE
  CREATE SERVER
  CREATE TABLE
  CREATE TABLE AS
  CREATE TABLESPACE
  CREATE TEXT SEARCH CONFIGURATION
  CREATE TEXT SEARCH DICTIONARY
  CREATE TEXT SEARCH PARSER
  CREATE TEXT SEARCH TEMPLATE
  CREATE TRIGGER
  CREATE TYPE
  CREATE USER
  CREATE USER MAPPING
  CREATE VIEW
 
  DEALLOCATE
 DECLARE
 DELETE
 DISCARD
 DO
 DROP AGGREGATE
 DROP CAST
 DROP COLLATION
 DROP CONVERSION
 DROP DATABASE
 DROP DOMAIN
 DROP EVENT TRIGGER
 DROP EXTENSION
 DROP FOREIGN DATA WRAPPER
 DROP FOREIGN TABLE
 DROP FUNCTION
 DROP GROUP
 DROP INDEX
 DROP LANGUAGE
 DROP MATERIALIZED VIEW
 DROP OPERATOR
 DROP OPERATOR CLASS
 DROP OPERATOR FAMILY
 DROP OWNED
 DROP ROLE
 DROP RULE
 DROP SCHEMA
 DROP SEQUENCE
 DROP SERVER
 DROP TABLE
 DROP TABLESPACE
 DROP TEXT SEARCH CONFIGURATION
 DROP TEXT SEARCH DICTIONARY
 DROP TEXT SEARCH PARSER
 DROP TEXT SEARCH TEMPLATE
 DROP TRIGGER
 DROP TYPE
 DROP USER
 DROP USER MAPPING
 DROP VIEW
 END
 EXECUTE
 EXPLAIN
 FETCH
 GRANT
 INSERT
 LISTEN
 LOAD
 LOCK
 MOVE
 NOTIFY
 PREPARE
 PREPARE TRANSACTION
 REASSIGN OWNED
 REFRESH MATERIALIZED VIEW
 REINDEX
 RELEASE SAVEPOINT
 RESET
 REVOKE
 ROLLBACK
 ROLLBACK PREPARED
 ROLLBACK TO SAVEPOINT
 SAVEPOINT
 SECURITY LABEL
 SELECT
 SELECT INTO
 SET
 SET CONSTRAINTS
 SET ROLE
 SET SESSION AUTHORIZATION
 SET TRANSACTION
 SHOW
 START TRANSACTION
 TABLE
 TRUNCATE
 UNLISTEN
 UPDATE
 VACUUM
 VALUES
 WITH