[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] data deleting DELETE command 2nd hierarchies in PostgreSQL 2nd 3rd 4th 5th 6th 7th modifying UPDATE 2nd 3rd 4th organizing 2nd 3rd 4th 5th 6th 7th raw data retrieving from tables SELECT 2nd SELECT * FROM 2nd SELECT column-list FROM SELECT expression-list FROM SELECT single-column FROM viewing in Python data files securing 2nd directory structure of PostgreSQL installation directory trees 2nd permissions and ownership postmaster 2nd data sources ODBC 2nd 3rd setting up in Windows 2nd setting up on UNIX systems retrieving 2nd 3rd data types adding BLOBs Boolean 2nd operators syntax for literal values BYTEA 2nd 3rd operators storing large-objects 2nd 3rd 4th syntax for literal values 2nd 3rd C equivalents to PostgreSQL character data types character values string data types 2nd string operators 2nd 3rd string values 2nd 3rd creating your own data types 2nd custom data types 2nd date/time values arithmetic date/time operators 2nd date/time comparison operators operators syntax for literal values 2nd 3rd 4th temporal data types 2nd defining in C 2nd 3rd defining in PostgreSQL 2nd 3rd 4th 5th 6th defining simple data types 2nd 3rd 4th external forms 2nd fixed length data types geometric data types 2nd proximity operators 2nd size of syntax for literal values 2nd geometric data types. [See geometric data types] indicator variables 2nd 3rd 4th 5th 6th 7th internal forms 2nd INTERVAL mappings binary cursors network address data types. [See network address data types] NULL values 2nd numeric data types arithmetic operators for floats arithmetic operators for integers bit-shift operators bit-wise operators bit-wise operators for integers operators syntax for literal values 2nd numeric values alternate names for approximate numeric data types exact numeric data types OIDs. [See OIDs] operators pseudo data types PL/pgSQL 2nd 3rd 4th 5th SERIAL SEQUENCE string data types 2nd struct user -defined data types 2nd VARCHAR data/base directory data/global directory data/pg xlog directory database connections PHP database driver. [See DBD] database handle attributes processing queries Perl 2nd 3rd 4th 5th database handles database interface. [See DBI] database resources DatabaseMetaData interface (JDBC) databases as-distributed databases backing up 2nd pg dump 2nd 3rd 4th 5th 6th pg dumpall 2nd connecting 2nd 3rd 4th 5th connecting to simple queries 2nd 3rd creating CREATE DATABASE 2nd 3rd 4th 5th CREATE DATABASE command 2nd 3rd createdb 2nd createdb command 2nd DBI-compliant definition of dropping 2nd encoding for in JDBC architectural model installing sample database 2nd ODBC-compliant database relational databases relationships between clusters and tables 2nd restoring pg restore 2nd sample database. [See sample database] viewing 2nd viewing all databases in clusters DataSource class (JDBC) DATE date values formatting column results 2nd 3rd 4th 5th 6th date/time comparison operators date/time values DATE INTERVAL operators arithmetic date/time operators 2nd date/time comparison operators syntax for literal values 2nd 3rd 4th INTERVAL TIME TIME WITH TIME ZONE TIMESTAMP TIMESTAMP WITHOUT TIME ZONE dates displaying in ISO fprmats DATESTYLE display formats 2nd DB-API 2nd exception types DBD printing lists of available drivers Perl DBD (database driver) DBI 2nd architecture of 2nd 3rd compliant databases error checking 2nd 3rd 4th processing queries 2nd 3rd 4th 5th 6th prepare/execute model 2nd 3rd 4th 5th DBI (database interface) DBI PASS DBI URL 2nd 3rd 4th DBI USER dead tuples 2nd 3rd 4th removing DEBUG DEADLOCKS DEBUG LEVEL DEBUG PRETTY PRINT DEBUG PRINT PARSE DEBUG PRINT PLAN DEBUG PRINT QUERY DEBUG PRINT REWRITTEN DEBUG severity debugging dynamic SQL ecpg debugging parameters DEBUG DEADLOCKS DEBUG LEVEL DEBUG PRETTY PRINT DEBUG PRINT PARSE DEBUG PRINT PLAN DEBUG PRINT QUERY DEBUG PRINT REWRITTEN SYSLOG SYSLOG FACILITY SYSLOG IDENT TRACE LOCK OIDMIN TRACE LOCK TABLE TRACE LOCKS TRACE LWLOCKS TRACE NOTIFY TRACE USER LOCKS DECLARE PL/pgSQL 2nd 3rd 4th Declare() Declare() function DECLARE ‰CURSOR command decreasing page size DEFAULT TRANSACTION ISOLATION DELETE command 2nd deleting data DELETE command 2nd referents rows deleting. [See also dropping]2nd [See also removing] DESC descriptions table descriptions viewing 2nd 3rd descriptors dynamic SQL ecpg item types destination destroying views diagrams syntax diagrams 2nd dialog displaying to users Python dialog boxes Tcl connection dialog box 2nd 3rd 4th 5th 6th 7th sharing code for 2nd 3rd die() dir ctx current directives include() PHP use DBI use strict directories $PGDATA securing data files 2nd contrib data/base directory data/globa directories data/pg xlog directories structure of PostgreSQL installation data/base directory data/global directory data/pg xlog directory structure of stasndard PostgreSQL installation 2nd 3rd directory trees securing data files 2nd dirty read problem DISCONNECT statement 2nd disconnectdb() libpgeasy disconnecting f rom servers;libpgeasy display formats DATESTYLE 2nd displayErrors() ODBC interactive query processors 2nd 3rd displaying dates in ISO formats dialog to users in Python distance operators geometric data types DISTINCT selecting specific rows 2nd DISTINCT ON selecting specific rows do autocommit() do commit() do help() 2nd do ping() do quit() do rollback() do show table() 2nd do show tables() do show types() 2nd 3rd do sql command() 2nd 3rd do trace() do transaction() do() 2nd OEO 2nd undef doquery() 2nd double dash (--) DOUBLE PRECEISIOn doubling buffer count cache hits 2nd 3rd 4th downloading source code for installation on Unix/Linux systems 2nd 3rd 4th driver ODBC Driver class (JDBC) driver manager ODBC DriverManager class (JDBC) drivers PostgreSQL JDBC driver obtaining PostgreSQL ODBC drivers installing 2nd 3rd 4th 5th 6th 7th 8th drivers (JDBC) loading at runtime DROP DATABASE command 2nd DROP FUNCTION PL/pgSQL DROP GROUP DROP SCHEMA command DROP TABLE command 2nd 3rd 4th 5th DROP USER DROP VIEW command dropdb dropping databases 2nd functions PL/pgSQL tables DROP TABLE command 2nd 3rd 4th 5th dropping. [See also deleting] dsn properties omitting dump results() dump sqlca () duplicate value errors DYNAMIC LIBRARY PATH dynamic SQL debugging ecpg 2nd dynamic web pages PHP |