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