[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] ecpg 2nd autocommit connecting to servers 2nd 3rd 4th connection strings 2nd 3rd preprocessors 2nd 3rd 4th debugging dynamic SQL 2nd error checking EXEC SQL WHENEVER 2nd 3rd 4th 5th 6th sqlca 2nd 3rd 4th 5th 6th 7th interactive query processors 2nd 3rd 4th 5th 6th 7th 8th 9th is select stmt() print column headers() print meta data() 2nd 3rd 4th 5th process select statement() 2nd 3rd prerequisites for 2nd 3rd processing SQL commands 2nd 3rd data types 2nd 3rd 4th 5th 6th 7th indicator variables 2nd 3rd 4th retrieving column count runtime errors static applications EDPGdebug() EFFECTIVE CACHE SIZE ELSIF embedded strings quoting (PL/pgSQL) embedding quotes within strings SQL commands in C programs ecpg. [See ecpg] empty commands executing using pg query() ENABLE HASHJOIN ENABLE INDEXSCAN ENABLE MERGEJOIN ENABLE NESTLOOP ENABLE SEQSCAN ENABLE SORT ENABLE TIDSCAN enabling locale support 2nd multibyte support 2nd encoding for databases encoding schemes selecting 2nd 3rd supported by PostgreSQL 2nd 3rd 4th 5th ENCODING= character-set clause ENCRYPTED PASSWORD END LOOP PL/pgSQL EndTransaction() environment handles ODBC 2nd 3rd environment variables psql error checking adding libpq++ 2nd 3rd 4th adding to clients libpgeasy 2nd 3rd 4th DBI 2nd 3rd 4th ecpg EXEC SQL WHENEVER 2nd 3rd 4th 5th 6th sqlca 2nd 3rd 4th 5th 6th 7th JDBC 2nd 3rd 4th 5th 6th libpq 2nd 3rd viewing connection attribuutes 2nd 3rd 4th ODBC 2nd exit() printErrors() 2nd 3rd SQLDriverConnect() 2nd 3rd SQLError() SQLSTATE 2nd Perl 2nd 3rd 4th PHP 2nd 3rd 4th 5th 6th 7th Python 2nd 3rd 4th 5th Tcl connections 2nd Tcl query processing error handling PL/pgSQL error messages ODBC PHP retrieving ODBC SQLError() retrieving text libpq++ errors duplicate value errors runtime errors ecpg StandardError Python escape character eval{} exact numeric data types EXCEPT EXCEPT ALL exception types Python DB-API exceptions. [See also error checking] EXEC SQL BEGIN DECLARE SECTION EXEC SQL CONNECT command EXEC SQL END DECLARE SECTION EXEC SQL GET DESCRIPTOR EXEC SQL INCLUDE EXEC SQL TYPE EXEC SQL WHENEVER error checking ecpg 2nd 3rd 4th 5th 6th Exec() ExecCommandOk() ExecTuplesOk() EXECUTE PL/pgSQL 2nd execute() execute() method (JDBC) executeQuery() method (JDBC) 2nd executeStmt() ODBC executeUpdate() method (JDBC) executing commands 2nd 3rd 4th 5th other than SELECT 2nd Python 2nd empty commands using pg query() queries Aggregate 2nd Append 2nd 3rd 4th EXPLAIN 2nd 3rd 4th 5th 6th Group 2nd Hash 2nd Hash Join how PostgreSQL executes queries 2nd 3rd 4th Index Scan 2nd Limit 2nd Materialize 2nd Merge Join 2nd 3rd 4th Nested Loop 2nd Result 2nd Seq Scan 2nd 3rd Setop 2nd 3rd 4th Sort 2nd Subplan Subquery Scan Tid Scan Unique 2nd EXIT loop constructs PL/pgSQL PL/pgSQL 2nd exit() ODBC error checking EXPLAIN ANALYZE EXPLAIN statement executing queries 2nd 3rd 4th 5th 6th expressions complex expressions regular expressions matching patterns 2nd 3rd type conversion functions type conversions extension functions adding 2nd 3rd 4th 5th 6th 7th CREATE FUNCTION command filesize function 2nd 3rd returning multiple values from 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th stat() function 2nd 3rd writing in C 2nd 3rd extensions finding location of external forms of data types 2nd external languages server-side programming 2nd EXTRACT() function |