I386LINUX/util/I386LINUX/doc/postgresql/html/client-interfaces.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Client Interfaces</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="PREVIOUS"
  15 TITLE="Platform-specific comparison files"
  16 HREF="regress-platform.html"><LINK
  17 REL="NEXT"
  18 TITLE="libpq - C Library"
  19 HREF="libpq.html"><LINK
  20 REL="STYLESHEET"
  21 TYPE="text/css"
  22 HREF="stylesheet.css"><META
  23 NAME="creation"
  24 CONTENT="2003-12-22T03:48:47"></HEAD
  25 ><BODY
  26 CLASS="PART"
  27 ><DIV
  28 CLASS="NAVHEADER"
  29 ><TABLE
  30 SUMMARY="Header navigation table"
  31 WIDTH="100%"
  32 BORDER="0"
  33 CELLPADDING="0"
  34 CELLSPACING="0"
  35 ><TR
  36 ><TH
  37 COLSPAN="5"
  38 ALIGN="center"
  39 VALIGN="bottom"
  40 >PostgreSQL 7.4.1 Documentation</TH
  41 ></TR
  42 ><TR
  43 ><TD
  44 WIDTH="10%"
  45 ALIGN="left"
  46 VALIGN="top"
  47 ><A
  48 HREF="regress-platform.html"
  49 ACCESSKEY="P"
  50 >Prev</A
  51 ></TD
  52 ><TD
  53 WIDTH="10%"
  54 ALIGN="left"
  55 VALIGN="top"
  56 ><A
  57 HREF="admin.html"
  58 >Fast Backward</A
  59 ></TD
  60 ><TD
  61 WIDTH="60%"
  62 ALIGN="center"
  63 VALIGN="bottom"
  64 ></TD
  65 ><TD
  66 WIDTH="10%"
  67 ALIGN="right"
  68 VALIGN="top"
  69 ><A
  70 HREF="server-programming.html"
  71 >Fast Forward</A
  72 ></TD
  73 ><TD
  74 WIDTH="10%"
  75 ALIGN="right"
  76 VALIGN="top"
  77 ><A
  78 HREF="libpq.html"
  79 ACCESSKEY="N"
  80 >Next</A
  81 ></TD
  82 ></TR
  83 ></TABLE
  84 ><HR
  85 ALIGN="LEFT"
  86 WIDTH="100%"></DIV
  87 ><DIV
  88 CLASS="PART"
  89 ><A
  90 NAME="CLIENT-INTERFACES"
  91 ></A
  92 ><DIV
  93 CLASS="TITLEPAGE"
  94 ><H1
  95 CLASS="TITLE"
  96 >IV. Client Interfaces</H1
  97 ><DIV
  98 CLASS="PARTINTRO"
  99 ><A
 100 NAME="AEN19840"
 101 ></A
 102 ><P
 103 >    This part describes the client programming interfaces distributed
 104     with <SPAN
 105 CLASS="PRODUCTNAME"
 106 >PostgreSQL</SPAN
 107 >.  Each of these chapters can be
 108     read independently.  Note that there are many other programming
 109     interfaces for client programs that are distributed separately and
 110     contain their own documentation.  Readers of this part should be
 111     familiar with using <ACRONYM
 112 CLASS="ACRONYM"
 113 >SQL</ACRONYM
 114 > commands to manipulate
 115     and query the database (see <A
 116 HREF="sql.html"
 117 >Part II</A
 118 >) and of course
 119     with the programming language that the interface uses.
 120    </P
 121 ></DIV
 122 ><DIV
 123 CLASS="TOC"
 124 ><DL
 125 ><DT
 126 ><B
 127 >Table of Contents</B
 128 ></DT
 129 ><DT
 130 >27. <A
 131 HREF="libpq.html"
 132 ><SPAN
 133 CLASS="APPLICATION"
 134 >libpq</SPAN
 135 > - C Library</A
 136 ></DT
 137 ><DD
 138 ><DL
 139 ><DT
 140 >27.1. <A
 141 HREF="libpq.html#LIBPQ-CONNECT"
 142 >Database Connection Control Functions</A
 143 ></DT
 144 ><DT
 145 >27.2. <A
 146 HREF="libpq-status.html"
 147 >Connection Status Functions</A
 148 ></DT
 149 ><DT
 150 >27.3. <A
 151 HREF="libpq-exec.html"
 152 >Command Execution Functions</A
 153 ></DT
 154 ><DT
 155 >27.4. <A
 156 HREF="libpq-async.html"
 157 >Asynchronous Command Processing</A
 158 ></DT
 159 ><DT
 160 >27.5. <A
 161 HREF="libpq-fastpath.html"
 162 >The Fast-Path Interface</A
 163 ></DT
 164 ><DT
 165 >27.6. <A
 166 HREF="libpq-notify.html"
 167 >Asynchronous Notification</A
 168 ></DT
 169 ><DT
 170 >27.7. <A
 171 HREF="libpq-copy.html"
 172 >Functions Associated with the <TT
 173 CLASS="COMMAND"
 174 >COPY</TT
 175 > Command</A
 176 ></DT
 177 ><DT
 178 >27.8. <A
 179 HREF="libpq-control.html"
 180 >Control Functions</A
 181 ></DT
 182 ><DT
 183 >27.9. <A
 184 HREF="libpq-notice-processing.html"
 185 >Notice Processing</A
 186 ></DT
 187 ><DT
 188 >27.10. <A
 189 HREF="libpq-envars.html"
 190 >Environment Variables</A
 191 ></DT
 192 ><DT
 193 >27.11. <A
 194 HREF="libpq-pgpass.html"
 195 >The Password File</A
 196 ></DT
 197 ><DT
 198 >27.12. <A
 199 HREF="libpq-threading.html"
 200 >Behavior in Threaded Programs</A
 201 ></DT
 202 ><DT
 203 >27.13. <A
 204 HREF="libpq-build.html"
 205 >Building <SPAN
 206 CLASS="APPLICATION"
 207 >libpq</SPAN
 208 > Programs</A
 209 ></DT
 210 ><DT
 211 >27.14. <A
 212 HREF="libpq-example.html"
 213 >Example Programs</A
 214 ></DT
 215 ></DL
 216 ></DD
 217 ><DT
 218 >28. <A
 219 HREF="largeobjects.html"
 220 >Large Objects</A
 221 ></DT
 222 ><DD
 223 ><DL
 224 ><DT
 225 >28.1. <A
 226 HREF="largeobjects.html#LO-HISTORY"
 227 >History</A
 228 ></DT
 229 ><DT
 230 >28.2. <A
 231 HREF="lo-implementation.html"
 232 >Implementation Features</A
 233 ></DT
 234 ><DT
 235 >28.3. <A
 236 HREF="lo-interfaces.html"
 237 >Client Interfaces</A
 238 ></DT
 239 ><DT
 240 >28.4. <A
 241 HREF="lo-funcs.html"
 242 >Server-Side Functions</A
 243 ></DT
 244 ><DT
 245 >28.5. <A
 246 HREF="lo-examplesect.html"
 247 >Example Program</A
 248 ></DT
 249 ></DL
 250 ></DD
 251 ><DT
 252 >29. <A
 253 HREF="pgtcl.html"
 254 ><SPAN
 255 CLASS="APPLICATION"
 256 >pgtcl</SPAN
 257 > - Tcl Binding Library</A
 258 ></DT
 259 ><DD
 260 ><DL
 261 ><DT
 262 >29.1. <A
 263 HREF="pgtcl.html#PGTCL-OVERVIEW"
 264 >Overview</A
 265 ></DT
 266 ><DT
 267 >29.2. <A
 268 HREF="libpgtcl-loading.html"
 269 >Loading <SPAN
 270 CLASS="APPLICATION"
 271 >pgtcl</SPAN
 272 > into an Application</A
 273 ></DT
 274 ><DT
 275 >29.3. <A
 276 HREF="libpgtcl-ref.html"
 277 ><SPAN
 278 CLASS="APPLICATION"
 279 >pgtcl</SPAN
 280 > Command Reference</A
 281 ></DT
 282 ><DT
 283 >29.4. <A
 284 HREF="pgtcl-examplesect.html"
 285 >Example Program</A
 286 ></DT
 287 ></DL
 288 ></DD
 289 ><DT
 290 >30. <A
 291 HREF="ecpg.html"
 292 ><SPAN
 293 CLASS="APPLICATION"
 294 >ECPG</SPAN
 295 > - Embedded <ACRONYM
 296 CLASS="ACRONYM"
 297 >SQL</ACRONYM
 298 > in C</A
 299 ></DT
 300 ><DD
 301 ><DL
 302 ><DT
 303 >30.1. <A
 304 HREF="ecpg.html#ECPG-CONCEPT"
 305 >The Concept</A
 306 ></DT
 307 ><DT
 308 >30.2. <A
 309 HREF="ecpg-connect.html"
 310 >Connecting to the Database Server</A
 311 ></DT
 312 ><DT
 313 >30.3. <A
 314 HREF="ecpg-disconnect.html"
 315 >Closing a Connection</A
 316 ></DT
 317 ><DT
 318 >30.4. <A
 319 HREF="ecpg-commands.html"
 320 >Running SQL Commands</A
 321 ></DT
 322 ><DT
 323 >30.5. <A
 324 HREF="ecpg-set-connection.html"
 325 >Choosing a Connection</A
 326 ></DT
 327 ><DT
 328 >30.6. <A
 329 HREF="ecpg-variables.html"
 330 >Using Host Variables</A
 331 ></DT
 332 ><DT
 333 >30.7. <A
 334 HREF="ecpg-dynamic.html"
 335 >Dynamic SQL</A
 336 ></DT
 337 ><DT
 338 >30.8. <A
 339 HREF="ecpg-descriptors.html"
 340 >Using SQL Descriptor Areas</A
 341 ></DT
 342 ><DT
 343 >30.9. <A
 344 HREF="ecpg-errors.html"
 345 >Error Handling</A
 346 ></DT
 347 ><DT
 348 >30.10. <A
 349 HREF="ecpg-include.html"
 350 >Including Files</A
 351 ></DT
 352 ><DT
 353 >30.11. <A
 354 HREF="ecpg-process.html"
 355 >Processing Embedded SQL Programs</A
 356 ></DT
 357 ><DT
 358 >30.12. <A
 359 HREF="ecpg-library.html"
 360 >Library Functions</A
 361 ></DT
 362 ><DT
 363 >30.13. <A
 364 HREF="ecpg-develop.html"
 365 >Internals</A
 366 ></DT
 367 ></DL
 368 ></DD
 369 ><DT
 370 >31. <A
 371 HREF="jdbc.html"
 372 ><ACRONYM
 373 CLASS="ACRONYM"
 374 >JDBC</ACRONYM
 375 > Interface</A
 376 ></DT
 377 ><DD
 378 ><DL
 379 ><DT
 380 >31.1. <A
 381 HREF="jdbc.html#JDBC-SETUP"
 382 >Setting up the <ACRONYM
 383 CLASS="ACRONYM"
 384 >JDBC</ACRONYM
 385 > Driver</A
 386 ></DT
 387 ><DT
 388 >31.2. <A
 389 HREF="jdbc-use.html"
 390 >Initializing the Driver</A
 391 ></DT
 392 ><DT
 393 >31.3. <A
 394 HREF="jdbc-query.html"
 395 >Issuing a Query and Processing the Result</A
 396 ></DT
 397 ><DT
 398 >31.4. <A
 399 HREF="jdbc-update.html"
 400 >Performing Updates</A
 401 ></DT
 402 ><DT
 403 >31.5. <A
 404 HREF="jdbc-callproc.html"
 405 >Calling Stored Functions</A
 406 ></DT
 407 ><DT
 408 >31.6. <A
 409 HREF="jdbc-ddl.html"
 410 >Creating and Modifying Database Objects</A
 411 ></DT
 412 ><DT
 413 >31.7. <A
 414 HREF="jdbc-binary-data.html"
 415 >Storing Binary Data</A
 416 ></DT
 417 ><DT
 418 >31.8. <A
 419 HREF="jdbc-ext.html"
 420 ><SPAN
 421 CLASS="APPLICATION"
 422 >PostgreSQL</SPAN
 423 > Extensions to the
 424     <ACRONYM
 425 CLASS="ACRONYM"
 426 >JDBC</ACRONYM
 427 > <ACRONYM
 428 CLASS="ACRONYM"
 429 >API</ACRONYM
 430 ></A
 431 ></DT
 432 ><DT
 433 >31.9. <A
 434 HREF="jdbc-thread.html"
 435 >Using the Driver in a Multithreaded or a Servlet Environment</A
 436 ></DT
 437 ><DT
 438 >31.10. <A
 439 HREF="jdbc-datasource.html"
 440 >Connection Pools and Data Sources</A
 441 ></DT
 442 ><DT
 443 >31.11. <A
 444 HREF="jdbc-reading.html"
 445 >Further Reading</A
 446 ></DT
 447 ></DL
 448 ></DD
 449 ><DT
 450 >32. <A
 451 HREF="information-schema.html"
 452 >The Information Schema</A
 453 ></DT
 454 ><DD
 455 ><DL
 456 ><DT
 457 >32.1. <A
 458 HREF="information-schema.html#INFOSCHEMA-SCHEMA"
 459 >The Schema</A
 460 ></DT
 461 ><DT
 462 >32.2. <A
 463 HREF="infoschema-datatypes.html"
 464 >Data Types</A
 465 ></DT
 466 ><DT
 467 >32.3. <A
 468 HREF="infoschema-information-schema-catalog-name.html"
 469 ><TT
 470 CLASS="LITERAL"
 471 >information_schema_catalog_name</TT
 472 ></A
 473 ></DT
 474 ><DT
 475 >32.4. <A
 476 HREF="infoschema-applicable-roles.html"
 477 ><TT
 478 CLASS="LITERAL"
 479 >applicable_roles</TT
 480 ></A
 481 ></DT
 482 ><DT
 483 >32.5. <A
 484 HREF="infoschema-check-constraints.html"
 485 ><TT
 486 CLASS="LITERAL"
 487 >check_constraints</TT
 488 ></A
 489 ></DT
 490 ><DT
 491 >32.6. <A
 492 HREF="infoschema-column-domain-usage.html"
 493 ><TT
 494 CLASS="LITERAL"
 495 >column_domain_usage</TT
 496 ></A
 497 ></DT
 498 ><DT
 499 >32.7. <A
 500 HREF="infoschema-column-privileges.html"
 501 ><TT
 502 CLASS="LITERAL"
 503 >column_privileges</TT
 504 ></A
 505 ></DT
 506 ><DT
 507 >32.8. <A
 508 HREF="infoschema-column-udt-usage.html"
 509 ><TT
 510 CLASS="LITERAL"
 511 >column_udt_usage</TT
 512 ></A
 513 ></DT
 514 ><DT
 515 >32.9. <A
 516 HREF="infoschema-columns.html"
 517 ><TT
 518 CLASS="LITERAL"
 519 >columns</TT
 520 ></A
 521 ></DT
 522 ><DT
 523 >32.10. <A
 524 HREF="infoschema-constraint-column-usage.html"
 525 ><TT
 526 CLASS="LITERAL"
 527 >constraint_column_usage</TT
 528 ></A
 529 ></DT
 530 ><DT
 531 >32.11. <A
 532 HREF="infoschema-constraint-table-usage.html"
 533 ><TT
 534 CLASS="LITERAL"
 535 >constraint_table_usage</TT
 536 ></A
 537 ></DT
 538 ><DT
 539 >32.12. <A
 540 HREF="infoschema-data-type-privileges.html"
 541 ><TT
 542 CLASS="LITERAL"
 543 >data_type_privileges</TT
 544 ></A
 545 ></DT
 546 ><DT
 547 >32.13. <A
 548 HREF="infoschema-domain-constraints.html"
 549 ><TT
 550 CLASS="LITERAL"
 551 >domain_constraints</TT
 552 ></A
 553 ></DT
 554 ><DT
 555 >32.14. <A
 556 HREF="infoschema-domain-udt-usage.html"
 557 ><TT
 558 CLASS="LITERAL"
 559 >domain_udt_usage</TT
 560 ></A
 561 ></DT
 562 ><DT
 563 >32.15. <A
 564 HREF="infoschema-domains.html"
 565 ><TT
 566 CLASS="LITERAL"
 567 >domains</TT
 568 ></A
 569 ></DT
 570 ><DT
 571 >32.16. <A
 572 HREF="infoschema-element-types.html"
 573 ><TT
 574 CLASS="LITERAL"
 575 >element_types</TT
 576 ></A
 577 ></DT
 578 ><DT
 579 >32.17. <A
 580 HREF="infoschema-enabled-roles.html"
 581 ><TT
 582 CLASS="LITERAL"
 583 >enabled_roles</TT
 584 ></A
 585 ></DT
 586 ><DT
 587 >32.18. <A
 588 HREF="infoschema-key-column-usage.html"
 589 ><TT
 590 CLASS="LITERAL"
 591 >key_column_usage</TT
 592 ></A
 593 ></DT
 594 ><DT
 595 >32.19. <A
 596 HREF="infoschema-parameters.html"
 597 ><TT
 598 CLASS="LITERAL"
 599 >parameters</TT
 600 ></A
 601 ></DT
 602 ><DT
 603 >32.20. <A
 604 HREF="infoschema-referential-constraints.html"
 605 ><TT
 606 CLASS="LITERAL"
 607 >referential_constraints</TT
 608 ></A
 609 ></DT
 610 ><DT
 611 >32.21. <A
 612 HREF="infoschema-role-column-grants.html"
 613 ><TT
 614 CLASS="LITERAL"
 615 >role_column_grants</TT
 616 ></A
 617 ></DT
 618 ><DT
 619 >32.22. <A
 620 HREF="infoschema-role-routine-grants.html"
 621 ><TT
 622 CLASS="LITERAL"
 623 >role_routine_grants</TT
 624 ></A
 625 ></DT
 626 ><DT
 627 >32.23. <A
 628 HREF="infoschema-role-table-grants.html"
 629 ><TT
 630 CLASS="LITERAL"
 631 >role_table_grants</TT
 632 ></A
 633 ></DT
 634 ><DT
 635 >32.24. <A
 636 HREF="infoschema-role-usage-grants.html"
 637 ><TT
 638 CLASS="LITERAL"
 639 >role_usage_grants</TT
 640 ></A
 641 ></DT
 642 ><DT
 643 >32.25. <A
 644 HREF="infoschema-routine-privileges.html"
 645 ><TT
 646 CLASS="LITERAL"
 647 >routine_privileges</TT
 648 ></A
 649 ></DT
 650 ><DT
 651 >32.26. <A
 652 HREF="infoschema-routines.html"
 653 ><TT
 654 CLASS="LITERAL"
 655 >routines</TT
 656 ></A
 657 ></DT
 658 ><DT
 659 >32.27. <A
 660 HREF="infoschema-schemata.html"
 661 ><TT
 662 CLASS="LITERAL"
 663 >schemata</TT
 664 ></A
 665 ></DT
 666 ><DT
 667 >32.28. <A
 668 HREF="infoschema-sql-features.html"
 669 ><TT
 670 CLASS="LITERAL"
 671 >sql_features</TT
 672 ></A
 673 ></DT
 674 ><DT
 675 >32.29. <A
 676 HREF="infoschema-sql-implementation-info.html"
 677 ><TT
 678 CLASS="LITERAL"
 679 >sql_implementation_info</TT
 680 ></A
 681 ></DT
 682 ><DT
 683 >32.30. <A
 684 HREF="infoschema-sql-languages.html"
 685 ><TT
 686 CLASS="LITERAL"
 687 >sql_languages</TT
 688 ></A
 689 ></DT
 690 ><DT
 691 >32.31. <A
 692 HREF="infoschema-sql-packages.html"
 693 ><TT
 694 CLASS="LITERAL"
 695 >sql_packages</TT
 696 ></A
 697 ></DT
 698 ><DT
 699 >32.32. <A
 700 HREF="infoschema-sql-sizing.html"
 701 ><TT
 702 CLASS="LITERAL"
 703 >sql_sizing</TT
 704 ></A
 705 ></DT
 706 ><DT
 707 >32.33. <A
 708 HREF="infoschema-sql-sizing-profiles.html"
 709 ><TT
 710 CLASS="LITERAL"
 711 >sql_sizing_profiles</TT
 712 ></A
 713 ></DT
 714 ><DT
 715 >32.34. <A
 716 HREF="infoschema-table-constraints.html"
 717 ><TT
 718 CLASS="LITERAL"
 719 >table_constraints</TT
 720 ></A
 721 ></DT
 722 ><DT
 723 >32.35. <A
 724 HREF="infoschema-table-privileges.html"
 725 ><TT
 726 CLASS="LITERAL"
 727 >table_privileges</TT
 728 ></A
 729 ></DT
 730 ><DT
 731 >32.36. <A
 732 HREF="infoschema-tables.html"
 733 ><TT
 734 CLASS="LITERAL"
 735 >tables</TT
 736 ></A
 737 ></DT
 738 ><DT
 739 >32.37. <A
 740 HREF="infoschema-triggers.html"
 741 ><TT
 742 CLASS="LITERAL"
 743 >triggers</TT
 744 ></A
 745 ></DT
 746 ><DT
 747 >32.38. <A
 748 HREF="infoschema-usage-privileges.html"
 749 ><TT
 750 CLASS="LITERAL"
 751 >usage_privileges</TT
 752 ></A
 753 ></DT
 754 ><DT
 755 >32.39. <A
 756 HREF="infoschema-view-column-usage.html"
 757 ><TT
 758 CLASS="LITERAL"
 759 >view_column_usage</TT
 760 ></A
 761 ></DT
 762 ><DT
 763 >32.40. <A
 764 HREF="infoschema-view-table-usage.html"
 765 ><TT
 766 CLASS="LITERAL"
 767 >view_table_usage</TT
 768 ></A
 769 ></DT
 770 ><DT
 771 >32.41. <A
 772 HREF="infoschema-views.html"
 773 ><TT
 774 CLASS="LITERAL"
 775 >views</TT
 776 ></A
 777 ></DT
 778 ></DL
 779 ></DD
 780 ></DL
 781 ></DIV
 782 ></DIV
 783 ></DIV
 784 ><DIV
 785 CLASS="NAVFOOTER"
 786 ><HR
 787 ALIGN="LEFT"
 788 WIDTH="100%"><TABLE
 789 SUMMARY="Footer navigation table"
 790 WIDTH="100%"
 791 BORDER="0"
 792 CELLPADDING="0"
 793 CELLSPACING="0"
 794 ><TR
 795 ><TD
 796 WIDTH="33%"
 797 ALIGN="left"
 798 VALIGN="top"
 799 ><A
 800 HREF="regress-platform.html"
 801 ACCESSKEY="P"
 802 >Prev</A
 803 ></TD
 804 ><TD
 805 WIDTH="34%"
 806 ALIGN="center"
 807 VALIGN="top"
 808 ><A
 809 HREF="index.html"
 810 ACCESSKEY="H"
 811 >Home</A
 812 ></TD
 813 ><TD
 814 WIDTH="33%"
 815 ALIGN="right"
 816 VALIGN="top"
 817 ><A
 818 HREF="libpq.html"
 819 ACCESSKEY="N"
 820 >Next</A
 821 ></TD
 822 ></TR
 823 ><TR
 824 ><TD
 825 WIDTH="33%"
 826 ALIGN="left"
 827 VALIGN="top"
 828 >Platform-specific comparison files</TD
 829 ><TD
 830 WIDTH="34%"
 831 ALIGN="center"
 832 VALIGN="top"
 833 >&nbsp;</TD
 834 ><TD
 835 WIDTH="33%"
 836 ALIGN="right"
 837 VALIGN="top"
 838 ><SPAN
 839 CLASS="APPLICATION"
 840 >libpq</SPAN
 841 > - C Library</TD
 842 ></TR
 843 ></TABLE
 844 ></DIV
 845 ></BODY
 846 ></HTML
 847 >