Tuesday, December 21, 2010

PostgreSQL Commands

Commands and its Description:
  1. ABORT--abort the current transaction
  2. ALTER AGGREGATE--change the definition of an aggregate function
  3. ALTER CONVERSION--change the definition of a conversion
  4. ALTER DATABASE--change a database
  5. ALTER DOMAIN-- change the definition of a domain
  6. ALTER FUNCTION--change the definition of a function
  7. ALTER GROUP--change role name or membership
  8. ALTER INDEX--change the definition of an index
  9. ALTER LANGUAGE--change the definition of a procedural language
  10. ALTER OPERATOR--change the definition of an operator
  11. ALTER OPERATOR CLASS--change the definition of an operator class
  12. ALTER ROLE--change a database role
  13. ALTER SCHEMA--change the definition of a schema
  14. ALTER SEQUENCE-- change the definition of a sequence generator
  15. ALTER TABLE--change the definition of a table
  16. ALTER TABLESPACE--change the definition of a tablespace
  17. ALTER TRIGGER--change the definition of a trigger
  18. ALTER TYPE-- change the definition of a type
  19. ALTER USER--change a database role
  20. ANALYZE--collect statistics about a database
  21. BEGIN--start a transaction block
  22. CHECKPOINT--force a transaction log checkpoint
  23. CLOSE--close a cursor
  24. CLUSTER--cluster a table according to an index
  25. COMMENT--define or change the comment of an object
  26. COMMIT--commit the current transaction
  27. COMMIT PREPARED--commit a transaction that was earlier prepared for two-phase commit
  28. COPY--copy data between a file and a table
  29. CREATE AGGREGATE--define a new aggregate function
  30. CREATE CAST--define a new cast
  31. CREATE CONSTRAINT TRIGGER--define a new constraint trigger
  32. CREATE CONVERSION--define a new encoding conversion
  33. CREATE DATABASE--create a new database
  34. CREATE DOMAIN--define a new domain
  35. CREATE FUNCTION--define a new function
  36. CREATE GROUP--define a new database role
  37. CREATE INDEX--define a new index
  38. CREATE LANGUAGE--define a new procedural language
  39. CREATE OPERATOR--define a new operator
  40. CREATE OPERATOR CLASS--define a new operator class
  41. CREATE ROLE--define a new database role
  42. CREATE RULE--define a new rewrite rule
  43. CREATE SCHEMA--define a new schema
  44. CREATE SEQUENCE--define a new sequence generator
  45. CREATE TABLE--define a new table
  46. CREATE TABLE AS--define a new table from the results of a query
  47. CREATE TABLESPACE--define a new tablespace
  48. CREATE TRIGGER--define a new trigger
  49. CREATE TYPE--define a new data type
  50. CREATE USER--define a new database role
  51. CREATE VIEW--define a new view
  52. DEALLOCATE--deallocate a prepared statement
  53. DECLARE--define a cursor
  54. DELETE--delete rows of a table
  55. DROP AGGREGATE--remove an aggregate function
  56. DROP CAST--remove a cast
  57. DROP CONVERSION--remove a conversion
  58. DROP DATABASE--remove a database
  59. DROP DOMAIN--remove a domain
  60. DROP FUNCTION--remove a function
  61. DROP GROUP--remove a database role
  62. DROP INDEX--remove an index
  63. DROP LANGUAGE--remove a procedural language
  64. DROP OPERATOR--remove an operator
  65. DROP OPERATOR CLASS--remove an operator class
  66. DROP ROLE--remove a database role
  67. DROP RULE--remove a rewrite rule
  68. DROP SCHEMA--remove a schema
  69. DROP SEQUENCE--remove a sequence
  70. DROP TABLE--remove a table
  71. DROP TABLESPACE--remove a tablespace
  72. DROP TRIGGER--remove a trigger
  73. DROP TYPE--remove a data type
  74. DROP USER--remove a database role
  75. DROP VIEW--remove a view
  76. END--commit the current transaction
  77. EXECUTE--execute a prepared statement
  78. EXPLAIN--show the execution plan of a statement
  79. FETCH--retrieve rows from a query using a cursor
  80. GRANT--define access privileges
  81. INSERT--create new rows in a table
  82. LISTEN--listen for a notification
  83. LOAD--load or reload a shared library file
  84. LOCK--lock a table
  85. MOVE--position a cursor
  86. NOTIFY--generate a notification
  87. PREPARE--prepare a statement for execution
  88. PREPARE TRANSACTION--prepare the current transaction for two-phase commit
  89. REINDEX--rebuild indexes
  90. RELEASE SAVEPOINT--destroy a previously defined savepoint
  91. RESET--restore the value of a run-time parameter to the default value
  92. REVOKE--remove access privileges
  93. ROLLBACK--abort the current transaction
  94. ROLLBACK PREPARED--cancel a transaction that was earlier prepared for two-phase commit
  95. ROLLBACK TO SAVEPOINT--roll back to a savepoint
  96. SAVEPOINT--define a new savepoint within the current transaction
  97. SELECT--retrieve rows from a table or view
  98. SELECT INTO--define a new table from the results of a query
  99. SET--change a run-time parameter
  100. SET CONSTRAINTS--set constraint checking modes for the current transaction
  101. SET ROLE--set the current user identifier of the current session
  102. SET SESSION AUTHORIZATION--set the session user identifier and the current user identifier of the current session
  103. SET TRANSACTION--set the characteristics of the current transaction
  104. SHOW--show the value of a run-time parameter
  105. START TRANSACTION--start a transaction block
  106. TRUNCATE--empty a table or set of tables
  107. UNLISTEN--stop listening for a notification
  108. UPDATE--update rows of a table
  109. VACUUM--garbage-collect and optionally analyze a database
PostgreSQL Client Applications:
  1. clusterdb --cluster a PostgreSQL database
  2. createdb --create a new PostgreSQL database
  3. createlang --define a new PostgreSQL procedural language
  4. createuser --define a new PostgreSQL user account
  5. dropdb --remove a PostgreSQL database
  6. droplang --remove a PostgreSQL procedural language
  7. dropuser --remove a PostgreSQL user account
  8. ecpg --embedded SQL C preprocessor
  9. pg_config --retrieve information about the installed version of PostgreSQL
  10. pg_dump -- extract a PostgreSQL database into a script file or other archive file
  11. pg_dumpall --extract a PostgreSQL database cluster into a script file
  12. pg_restore -- restore a PostgreSQL database from an archive file created by pg_dump
  13. psql -- PostgreSQL interactive terminal
  14. reindexdb --reindex a PostgreSQL database
  15. vacuumdb --garbage-collect and analyze a PostgreSQL database
PostgreSQL Server Applications:
  1. initdb --create a new PostgreSQL database cluster
  2. ipcclean --remove shared memory and semaphores from a failed PostgreSQL server
  3. pg_controldata --display control information of a PostgreSQL database cluster
  4. pg_ctl --start, stop, or restart a PostgreSQL server
  5. pg_resetxlog --reset the write-ahead log and other control information of a PostgreSQL database cluster
  6. postgres --run a PostgreSQL server in single-user mode
  7. postmaster --PostgreSQL multiuser database server

No comments:

Post a Comment