[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] labels PL/pgSQL 2nd 3rd LANG environement language Ids locales languages external languages server-side programming 2nd procedural languages 2nd 3rd trusted languages large-object API (libpgtcl library) 2nd 3rd 4th large-objects BYTEA 2nd 3rd 4th 5th 6th libpq++ 2nd 3rd 4th 5th 6th 7th LC COLLATE 2nd 3rd LC MESSAGES 2nd 3rd LC MONETARY LC NUMERIC LC TYPE left-shift operators (<<) libpgeasy connecting to servers 2nd 3rd 4th 5th error checking adding 2nd 3rd 4th interactive query processors 2nd 3rd 4th 5th 6th processing queries 2nd 3rd 4th 5th 6th binary cursors 2nd 3rd result sets 2nd libpgtcl library installing large-object API 2nd 3rd 4th loading performance tips shell programs in libpq 2nd 3rd and libpq++ asynchronous processing 2nd 3rd 4th 5th 6th 7th 8th byte-orderings connecting to servers 2nd 3rd compiling clients 2nd identifying the server 2nd 3rd 4th 5th 6th error checking 2nd 3rd viewing connection attributes 2nd 3rd 4th interactive query processors 2nd 3rd 4th 5th 6th 7th 8th 9th 10th makefiles keywords make 2nd 3rd PHP PQconnectdb() prerequisites for prerequisites for building clients processing multiple result sets 2nd 3rd 4th processing queries 2nd 3rd 4th binary cursors 2nd 3rd 4th 5th 6th results returned by PQexec() 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th libpq++ adding error checking 2nd 3rd 4th and libpq connecting to servers 2nd 3rd interactive query processors 2nd 3rd 4th 5th 6th 7th 8th 9th 10th large-objects 2nd 3rd 4th 5th 6th 7th PgCursor 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th PgDatabase 2nd 3rd 4th PgTransaction 2nd 3rd 4th 5th 6th processing queries qt-query 2nd 3rd 4th 5th 6th 7th 8th 9th retrieving error message test libpqgeasy libraries readline readline library LIKE matching patterns matching patterns with regular expressions SELECT LIMIT selecting specific rows 2nd Limit operator 2nd Linux installing PostgreSQL from binaries from source code, installing PostgreSQL on Unix/Linux systems locale names samples of locales finding runlevels starting PostgreSQL on startup 2nd 3rd 4th 5th listings 10.1\: client1.cpp 10.2\: client2.cpp 10.3\: qt-query.h 10.4\: qt-query.cpp 10.4a\: qt-query.cpp 10.5\: persist-tran.cpp 10.6\: qt-cursor.h 10.7\: qtcursor.cpp 2nd 3rd 4th 10.8\: qt-sql.h 10.9\: qt-sql.cpp 10.9a\: qt-sql.cpp 10.9b\: qt-sql.cpp 10.9c\: qt-sqp.cpp 10.9d\:qt-sql.cpp 10.9f\:qt-sql.cpp 12.1 Clinet1.c 12.2 client2.c 12.3 odbc/client3.c 14.1 get drivers.pl 14.10 print results and saved references 14.11 print results using fetchrow array 14.12 print results using fetchrow hashref 14.13 client3e.pl 14.14 client3e.pl--compute column widths 14.15 client3e.pl--pad 14.16 client3e.pl--print column headings 14.18 client3e.pl--modified mainline 14.19 client4.pl--mainline 14.2 get datasources.pl 14.20 client4.pl--do sql command 14.21 client4.pl--do autocommit 14.22 client4.pl--do commit, do rollback 14.23 client4.pl--do quit 14.24 client4.pl--do trace 14.25 client4.pl--do help 14.26 client4.pl--do show tables 14.28 client4.pl--do show table 14.29 client4.pl--print meta data 14.3 client1.pl 14.30 client4.pl--process results 14.4 client2a.pl 14.5 client2b.pl 14.6 client3a.pl 14.7 client3b.pl 14.8 client3c.pl 14.9 client3d.pl 15.1 Simple.php 15.10 client3a.php 15.11 my_table_a.php 15.12 append row() Using pg fetch row() 15.13 append row() Using pg fetch array() 15.14 my table.start table() 15.15 my table.append row() 15.16 client4.html 15.17 client4a.php 15.18 my table.my table() 15.19 my table.my table() Final Form 15.2 SimpleHTML.php 15.3 Time.php 15.4 client1a.php 15.5 client1b.php 15.6 connect_pg.php 15.7 client2a.php 15.8 my_error_handler.php 15.9 client2b.php 17.1 client1.py 17.10 client4.py--PGDialog.main() 17.11 client4.py--PGDialog.build dialog() 17.12 client4.py--PGDialog.make table() 17.13 client4.py--PGDialog.execute() 17.15 client4.py--PGDialog.process command() 17.16 client4.py--PGDialog. size table() 17.17 client4.py--PGDialog.set column headers() 17.18 client4.py--PGDialog.fill table() 17.19 client4.py--PGDialog.size columns () 17.2 client2a.py 17.20 client4.py--mainline code 17.3 client2b.py 17.4 client3.py--main() 17.4 client3.py--process results() 17.6 client3.py--compute widths() 17.7 client3.py--print headers() 17.8 client3.py--print values() and mainline 17.9 client4.py--PGDialog.init() 1e4.17 client3e.pl--print results 20.1 get_encoding.sql client1.java (JDBC client application for server connections) 2nd client1.tcl (Tcl client application add_button procedure) 2nd client1.tcl (Tcl client application add_label_field procedure) 2nd client1.tcl (Tcl client application connection dialog box) 2nd client1.tcl (Tcl client application for server connections) 2nd client1.tcl (Tcl client application mainline code) client1a.tcl (Tcl client application for server connections) 2nd client2.java (JDBC error checking) 2nd client2.tcl (build_dialog procedure for Tcl client application for query processing) 2nd client2.tcl (fill_table procedure for Tcl client application for query processing) client2.tcl (load_table procedure for Tcl client application for query processing) client2.tcl (mainline code for Tcl client application for query processing) client2.tcl (make_table procedure for Tcl client application for query processing) 2nd client2.tcl (process_command procedure for Tcl client application for query processing) client2.tcl (set_column_headers procedure for Tcl client application for query processing) client2.tcl (size_columns procedure for Tcl client application for query processing) client2.tcl (size_table procedure for Tcl client application for query processing) client2.tcl (Tcl client application for query processing) 2nd client2a.java (JDBC error checking) 2nd client3.java (JDBC query processing, part 1) 2nd client3.java (JDBC query processing, part 2) 2nd client3.java (JDBC query processing, part 3) 2nd client3.java (JDBC query processing, part 4) 2nd client3.tcl (build_dialog procedure for Tcl interactive query processing) 2nd client3.tcl (process_command procedure for Tcl interactive query processing) 2nd client3.tcl (Tcl interactive query processing) 2nd client4.java (JDBC interactive query processing, part 1) 2nd client4.java (JDBC interactive query processing, part 2) 2nd client4.java (JDBC interactive query processing, part 3) 2nd client4.java (JDBC interactive query processing, part 4) 2nd client4.java (JDBC interactive query processing, part 5) 2nd client4.java (JDBC interactive query processing, part 6) 2nd client4.py--PGDialog.load table() makefile for JDBC sample applications (13.1) pgconnect.tcl (connect functions for sharing Tcl connection dialog box code) 2nd pgconnect.tcl (sharing Tcl connection dialog box code) 2nd listingsn 14.27 client4.pl--do show types lists sorting little-endian lo export() lo import() lo_export() function lo_import() function lo_unlink() function loading results into widgets Python local connections securing network access locales changing 2nd enabling support 2nd finding current locales information categories LC COLLATE 2nd 3rd LC MESSAGES LC MONETARY LC NUMERIC LC TYPE language IDs names samples of territories localization administrator's roles definition of location of extensions finding LOCATION= path clause locking LOG CONNECTIONS LOG PID LOG TIMESTAMP logging parameters DEBUG DEADLOCKS LOG CONNECTIONS LOG PID LOG TIMESTAMP SILENT MODE SYSLOG SYSLOG FACILITY SYSLOG IDENT TRACE LOCK OIDMIN TRACE LOCK TABLE TRACE LOCKS TRACE LWLOCKS TRACE NOTIFY TRACE USER LOCKS logical operators AND AND. [See AND] for BOOLEAN NOT NOT. [See NOT] OR OR. [See OR] logs config.log LOOP PL/pgSQL loop constructs integer-FOR loop PL/pgSQL 2nd END LOOP EXIT FOR 2nd 3rd 4th 5th 6th FOR-IN FOR-IN-EXECUTE FOR-IN-SELECT LOOP WHILE 2nd 3rd loop index loops FOR\:PL/pgSQL variables 2nd LSEG syntax for literal values |