1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="reference.html"><LINK
19
HREF="reference.html"><LINK
22
HREF="sql-abort.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
67
HREF="reference.html#AEN59273"
80
TITLE="PostgreSQL Client Applications"
81
HREF="reference-client.html"
115
> This part contains reference information for the
119
> commands supported by
127
language in general is meant; information about the standards
128
conformance and compatibility of each command can be found on the
129
respective reference page.
137
>Table of Contents</B
141
HREF="sql-abort.html"
143
> -- abort the current transaction</DT
146
HREF="sql-alteraggregate.html"
148
> -- change the definition of an aggregate function</DT
151
HREF="sql-altercollation.html"
153
> -- change the definition of a collation</DT
156
HREF="sql-alterconversion.html"
158
> -- change the definition of a conversion</DT
161
HREF="sql-alterdatabase.html"
163
> -- change a database</DT
166
HREF="sql-alterdefaultprivileges.html"
167
>ALTER DEFAULT PRIVILEGES</A
168
> -- define default access privileges</DT
171
HREF="sql-alterdomain.html"
173
> -- change the definition of a domain
177
HREF="sql-alterextension.html"
179
> -- change the definition of an extension
183
HREF="sql-alterforeigndatawrapper.html"
184
>ALTER FOREIGN DATA WRAPPER</A
185
> -- change the definition of a foreign-data wrapper</DT
188
HREF="sql-alterforeigntable.html"
189
>ALTER FOREIGN TABLE</A
190
> -- change the definition of a foreign table</DT
193
HREF="sql-alterfunction.html"
195
> -- change the definition of a function</DT
198
HREF="sql-altergroup.html"
200
> -- change role name or membership</DT
203
HREF="sql-alterindex.html"
205
> -- change the definition of an index</DT
208
HREF="sql-alterlanguage.html"
210
> -- change the definition of a procedural language</DT
213
HREF="sql-alterlargeobject.html"
214
>ALTER LARGE OBJECT</A
215
> -- change the definition of a large object</DT
218
HREF="sql-alteroperator.html"
220
> -- change the definition of an operator</DT
223
HREF="sql-alteropclass.html"
224
>ALTER OPERATOR CLASS</A
225
> -- change the definition of an operator class</DT
228
HREF="sql-alteropfamily.html"
229
>ALTER OPERATOR FAMILY</A
230
> -- change the definition of an operator family</DT
233
HREF="sql-alterrole.html"
235
> -- change a database role</DT
238
HREF="sql-alterschema.html"
240
> -- change the definition of a schema</DT
243
HREF="sql-altersequence.html"
245
> -- change the definition of a sequence generator
249
HREF="sql-alterserver.html"
251
> -- change the definition of a foreign server</DT
254
HREF="sql-altertable.html"
256
> -- change the definition of a table</DT
259
HREF="sql-altertablespace.html"
261
> -- change the definition of a tablespace</DT
264
HREF="sql-altertsconfig.html"
265
>ALTER TEXT SEARCH CONFIGURATION</A
266
> -- change the definition of a text search configuration</DT
269
HREF="sql-altertsdictionary.html"
270
>ALTER TEXT SEARCH DICTIONARY</A
271
> -- change the definition of a text search dictionary</DT
274
HREF="sql-altertsparser.html"
275
>ALTER TEXT SEARCH PARSER</A
276
> -- change the definition of a text search parser</DT
279
HREF="sql-altertstemplate.html"
280
>ALTER TEXT SEARCH TEMPLATE</A
281
> -- change the definition of a text search template</DT
284
HREF="sql-altertrigger.html"
286
> -- change the definition of a trigger</DT
289
HREF="sql-altertype.html"
291
> -- change the definition of a type
295
HREF="sql-alteruser.html"
297
> -- change a database role</DT
300
HREF="sql-alterusermapping.html"
301
>ALTER USER MAPPING</A
302
> -- change the definition of a user mapping</DT
305
HREF="sql-alterview.html"
307
> -- change the definition of a view</DT
310
HREF="sql-analyze.html"
312
> -- collect statistics about a database</DT
315
HREF="sql-begin.html"
317
> -- start a transaction block</DT
320
HREF="sql-checkpoint.html"
322
> -- force a transaction log checkpoint</DT
325
HREF="sql-close.html"
327
> -- close a cursor</DT
330
HREF="sql-cluster.html"
332
> -- cluster a table according to an index</DT
335
HREF="sql-comment.html"
337
> -- define or change the comment of an object</DT
340
HREF="sql-commit.html"
342
> -- commit the current transaction</DT
345
HREF="sql-commit-prepared.html"
347
> -- commit a transaction that was earlier prepared for two-phase commit</DT
352
> -- copy data between a file and a table</DT
355
HREF="sql-createaggregate.html"
357
> -- define a new aggregate function</DT
360
HREF="sql-createcast.html"
362
> -- define a new cast</DT
365
HREF="sql-createcollation.html"
367
> -- define a new collation</DT
370
HREF="sql-createconversion.html"
371
>CREATE CONVERSION</A
372
> -- define a new encoding conversion</DT
375
HREF="sql-createdatabase.html"
377
> -- create a new database</DT
380
HREF="sql-createdomain.html"
382
> -- define a new domain</DT
385
HREF="sql-createextension.html"
387
> -- install an extension</DT
390
HREF="sql-createforeigndatawrapper.html"
391
>CREATE FOREIGN DATA WRAPPER</A
392
> -- define a new foreign-data wrapper</DT
395
HREF="sql-createforeigntable.html"
396
>CREATE FOREIGN TABLE</A
397
> -- define a new foreign table</DT
400
HREF="sql-createfunction.html"
402
> -- define a new function</DT
405
HREF="sql-creategroup.html"
407
> -- define a new database role</DT
410
HREF="sql-createindex.html"
412
> -- define a new index</DT
415
HREF="sql-createlanguage.html"
417
> -- define a new procedural language</DT
420
HREF="sql-createoperator.html"
422
> -- define a new operator</DT
425
HREF="sql-createopclass.html"
426
>CREATE OPERATOR CLASS</A
427
> -- define a new operator class</DT
430
HREF="sql-createopfamily.html"
431
>CREATE OPERATOR FAMILY</A
432
> -- define a new operator family</DT
435
HREF="sql-createrole.html"
437
> -- define a new database role</DT
440
HREF="sql-createrule.html"
442
> -- define a new rewrite rule</DT
445
HREF="sql-createschema.html"
447
> -- define a new schema</DT
450
HREF="sql-createsequence.html"
452
> -- define a new sequence generator</DT
455
HREF="sql-createserver.html"
457
> -- define a new foreign server</DT
460
HREF="sql-createtable.html"
462
> -- define a new table</DT
465
HREF="sql-createtableas.html"
467
> -- define a new table from the results of a query</DT
470
HREF="sql-createtablespace.html"
471
>CREATE TABLESPACE</A
472
> -- define a new tablespace</DT
475
HREF="sql-createtsconfig.html"
476
>CREATE TEXT SEARCH CONFIGURATION</A
477
> -- define a new text search configuration</DT
480
HREF="sql-createtsdictionary.html"
481
>CREATE TEXT SEARCH DICTIONARY</A
482
> -- define a new text search dictionary</DT
485
HREF="sql-createtsparser.html"
486
>CREATE TEXT SEARCH PARSER</A
487
> -- define a new text search parser</DT
490
HREF="sql-createtstemplate.html"
491
>CREATE TEXT SEARCH TEMPLATE</A
492
> -- define a new text search template</DT
495
HREF="sql-createtrigger.html"
497
> -- define a new trigger</DT
500
HREF="sql-createtype.html"
502
> -- define a new data type</DT
505
HREF="sql-createuser.html"
507
> -- define a new database role</DT
510
HREF="sql-createusermapping.html"
511
>CREATE USER MAPPING</A
512
> -- define a new mapping of a user to a foreign server</DT
515
HREF="sql-createview.html"
517
> -- define a new view</DT
520
HREF="sql-deallocate.html"
522
> -- deallocate a prepared statement</DT
525
HREF="sql-declare.html"
527
> -- define a cursor</DT
530
HREF="sql-delete.html"
532
> -- delete rows of a table</DT
535
HREF="sql-discard.html"
537
> -- discard session state</DT
542
> -- execute an anonymous code block</DT
545
HREF="sql-dropaggregate.html"
547
> -- remove an aggregate function</DT
550
HREF="sql-dropcast.html"
552
> -- remove a cast</DT
555
HREF="sql-dropcollation.html"
557
> -- remove a collation</DT
560
HREF="sql-dropconversion.html"
562
> -- remove a conversion</DT
565
HREF="sql-dropdatabase.html"
567
> -- remove a database</DT
570
HREF="sql-dropdomain.html"
572
> -- remove a domain</DT
575
HREF="sql-dropextension.html"
577
> -- remove an extension</DT
580
HREF="sql-dropforeigndatawrapper.html"
581
>DROP FOREIGN DATA WRAPPER</A
582
> -- remove a foreign-data wrapper</DT
585
HREF="sql-dropforeigntable.html"
586
>DROP FOREIGN TABLE</A
587
> -- remove a foreign table</DT
590
HREF="sql-dropfunction.html"
592
> -- remove a function</DT
595
HREF="sql-dropgroup.html"
597
> -- remove a database role</DT
600
HREF="sql-dropindex.html"
602
> -- remove an index</DT
605
HREF="sql-droplanguage.html"
607
> -- remove a procedural language</DT
610
HREF="sql-dropoperator.html"
612
> -- remove an operator</DT
615
HREF="sql-dropopclass.html"
616
>DROP OPERATOR CLASS</A
617
> -- remove an operator class</DT
620
HREF="sql-dropopfamily.html"
621
>DROP OPERATOR FAMILY</A
622
> -- remove an operator family</DT
625
HREF="sql-drop-owned.html"
627
> -- remove database objects owned by a database role</DT
630
HREF="sql-droprole.html"
632
> -- remove a database role</DT
635
HREF="sql-droprule.html"
637
> -- remove a rewrite rule</DT
640
HREF="sql-dropschema.html"
642
> -- remove a schema</DT
645
HREF="sql-dropsequence.html"
647
> -- remove a sequence</DT
650
HREF="sql-dropserver.html"
652
> -- remove a foreign server descriptor</DT
655
HREF="sql-droptable.html"
657
> -- remove a table</DT
660
HREF="sql-droptablespace.html"
662
> -- remove a tablespace</DT
665
HREF="sql-droptsconfig.html"
666
>DROP TEXT SEARCH CONFIGURATION</A
667
> -- remove a text search configuration</DT
670
HREF="sql-droptsdictionary.html"
671
>DROP TEXT SEARCH DICTIONARY</A
672
> -- remove a text search dictionary</DT
675
HREF="sql-droptsparser.html"
676
>DROP TEXT SEARCH PARSER</A
677
> -- remove a text search parser</DT
680
HREF="sql-droptstemplate.html"
681
>DROP TEXT SEARCH TEMPLATE</A
682
> -- remove a text search template</DT
685
HREF="sql-droptrigger.html"
687
> -- remove a trigger</DT
690
HREF="sql-droptype.html"
692
> -- remove a data type</DT
695
HREF="sql-dropuser.html"
697
> -- remove a database role</DT
700
HREF="sql-dropusermapping.html"
701
>DROP USER MAPPING</A
702
> -- remove a user mapping for a foreign server</DT
705
HREF="sql-dropview.html"
707
> -- remove a view</DT
712
> -- commit the current transaction</DT
715
HREF="sql-execute.html"
717
> -- execute a prepared statement</DT
720
HREF="sql-explain.html"
722
> -- show the execution plan of a statement</DT
725
HREF="sql-fetch.html"
727
> -- retrieve rows from a query using a cursor</DT
730
HREF="sql-grant.html"
732
> -- define access privileges</DT
735
HREF="sql-insert.html"
737
> -- create new rows in a table</DT
740
HREF="sql-listen.html"
742
> -- listen for a notification</DT
747
> -- load a shared library file</DT
752
> -- lock a table</DT
757
> -- position a cursor</DT
760
HREF="sql-notify.html"
762
> -- generate a notification</DT
765
HREF="sql-prepare.html"
767
> -- prepare a statement for execution</DT
770
HREF="sql-prepare-transaction.html"
771
>PREPARE TRANSACTION</A
772
> -- prepare the current transaction for two-phase commit</DT
775
HREF="sql-reassign-owned.html"
777
> -- change the ownership of database objects owned by a database role</DT
780
HREF="sql-reindex.html"
782
> -- rebuild indexes</DT
785
HREF="sql-release-savepoint.html"
786
>RELEASE SAVEPOINT</A
787
> -- destroy a previously defined savepoint</DT
790
HREF="sql-reset.html"
792
> -- restore the value of a run-time parameter to the default value</DT
795
HREF="sql-revoke.html"
797
> -- remove access privileges</DT
800
HREF="sql-rollback.html"
802
> -- abort the current transaction</DT
805
HREF="sql-rollback-prepared.html"
806
>ROLLBACK PREPARED</A
807
> -- cancel a transaction that was earlier prepared for two-phase commit</DT
810
HREF="sql-rollback-to.html"
811
>ROLLBACK TO SAVEPOINT</A
812
> -- roll back to a savepoint</DT
815
HREF="sql-savepoint.html"
817
> -- define a new savepoint within the current transaction</DT
820
HREF="sql-security-label.html"
822
> -- define or change a security label applied to an object</DT
825
HREF="sql-select.html"
827
> -- retrieve rows from a table or view</DT
830
HREF="sql-selectinto.html"
832
> -- define a new table from the results of a query</DT
837
> -- change a run-time parameter</DT
840
HREF="sql-set-constraints.html"
842
> -- set constraint check timing for the current transaction</DT
845
HREF="sql-set-role.html"
847
> -- set the current user identifier of the current session</DT
850
HREF="sql-set-session-authorization.html"
851
>SET SESSION AUTHORIZATION</A
852
> -- set the session user identifier and the current user identifier of the current session</DT
855
HREF="sql-set-transaction.html"
857
> -- set the characteristics of the current transaction</DT
862
> -- show the value of a run-time parameter</DT
865
HREF="sql-start-transaction.html"
866
>START TRANSACTION</A
867
> -- start a transaction block</DT
870
HREF="sql-truncate.html"
872
> -- empty a table or set of tables</DT
875
HREF="sql-unlisten.html"
877
> -- stop listening for a notification</DT
880
HREF="sql-update.html"
882
> -- update rows of a table</DT
885
HREF="sql-vacuum.html"
887
> -- garbage-collect and optionally analyze a database</DT
890
HREF="sql-values.html"
892
> -- compute a set of rows</DT
902
SUMMARY="Footer navigation table"
913
HREF="reference.html"
931
HREF="sql-abort.html"
947
HREF="reference.html"
b'\\ No newline at end of file'