- access information file (ODBC),
Access Information File
- Apache
- starting or restarting,
Start or Restart the Apache Server
- C language functions
- base types,
Base Types in C-Language Functions
- calling conventions,
Calling Conventions for C-Language Functions
- composite types,
Composite Types in C-Language Functions
- function overloading,
Function Overloading
- overview,
Compiled (C) Language Functions
- triggers,
Triggers
- writing,
Writing Code
- c types and postgresql types,
Base Types in C-Language Functions
- CmdTuples
- gets the rows a command affects,
CmdTuples
- connectdb
- makes a new server connection,
Database Connection Functions
- Connection class
- JDBC,
Connection
- connection methods
- JDBC,
Connection Methods
- ConnectionBad
- returns the state of the database connection,
ConnectionBad
- data changes visibility,
Visibility of Data Changes
- database
- setting up,
Setting up Red Hat Database
- database connection functions
- enabled by libpq,
Database Connection Functions
- database objects
- creating and modifying,
Creating and Modifying Database Objects
- database schema
- creating,
Creating the Database Schema
- databases
- modifying,
Modifying Data and Databases
- DBName
- returns the name of the database,
DBName
- DELETE
- performing with executeUpdate,
Performing Updates
- disconnectdb
- closes a server connection,
Database Connection Functions
- doquery
- sends a query to the server,
Query Execution and Processing Functions
- dynamically-loaded functions
- compiling and linking,
Compiling and Linking Dynamically-Loaded Functions
- ecpg
- command-line options,
Using ecpg
- embedded SQL in C,
ecpg - Embedded SQL in C
- using,
Using ecpg
- embedded SQL
- connecting to a database,
Connecting to a Database
- disconnecting from a database,
Disconnecting from a Database
- error handling,
Error Handling
- overview,
Embedded SQL
- SQL commands,
SQL Commands
- variable declaration,
Variable Declaration
- ErrorMessage
- returns last error message,
ErrorMessage
- Exec
- sends a query to the server,
Exec
- ExecCommandOK
- sends a query to the server,
ExecCommandOk
- ExecTuplesOK
- sends a query to the server,
ExecTuplesOk
- Executor
- accessing,
Server Programming Interface
- Fastpath,
Fastpath
- fetch
- retrieves data from a binary cursor,
Query Execution and Processing Functions
- fetchwithnulls
- retrieves binary cursor data with NULLs,
Query Execution and Processing Functions
- FieldName
- returns the name of a column,
FieldName
- FieldNum
- returns the index of a column,
FieldNum
- Fields
- returns the number of columns,
Fields
- FieldSize
- returns the size of a column type,
FieldSize
- FieldType
- returns the Oid of a column type,
FieldType
- function overloading,
Function Overloading
- GetIsNull
- returns if a column value is NULL,
GetIsNull
- GetLength
- returns the length of a column value,
GetLength
- GetValue
- returns a single column value,
GetValue
- get_result
- returns the current internal result set,
Query Execution and Processing Functions
- JDBC
- closing a connection,
Closing the Connection
- Connection class,
Connection
- connection methods,
Connection Methods
- driver requirements,
Requirements for Java/JDBC
- Fastpath API,
Fastpath
- getting the driver,
Getting the Driver
- installing the driver,
Installing the Driver
- LargeObject class,
LargeObject
- LargeObjectManger class,
LargeObjectManager
- loading the driver,
Loading a Driver
- opening a connection,
Opening a Connection
- overview,
JDBC Interface
- PostgreSQL extensions to,
Red Hat Database Extensions to the JDBC API
- queries and results,
Queries and Results
- JDK
- acquiring,
Requirements for Java/JDBC
- Kerberos authentication
- requires a hostname,
PQconnectdb
- Large Objects (LOBs)
- accessing,
Accessing LOBs: The Standard JDBC Method
- accessing via LOB extensions,
Accessing LOBs Using the PostgreSQL LOB Extensions
- using,
Using Large Objects
- LargeObject class,
LargeObject
- libpgeasy
- simplified C library,
libpgeasy - Simplified libpq C Library
- libpq
- compiling with USE_SSL blocks PQconnectPoll,
PQconnectStart, PQconnectPoll
- libpq C library
- building programs,
Building libpq Programs
- example programs,
Example Programs
- overview,
libpq - C Library
- requires libpq-fe.h header file,
libpq - C Library
- threading behavior,
Threading Behavior
- libpq C++ library
- classes,
libpq++ - C++ Binding Library
- database connections,
PgConnection Database Connection Methods
- overview,
libpq++ - C++ Binding Library
- query execution functions,
PgConnection Query Execution Methods
- supports asynchronous notification,
PgConnection Asynchronous Notification Methods
- libpq-fe.h
- header file for libpq,
libpq - C Library
- lo_close
- closes a lob,
lo_close
- lo_creat
- creates a new large object,
lo_creat
- lo_export
- exports a lob into a Linux file,
lo_export
- lo_import
- imports a Linux file as a lob,
lo_import
- lo_lseek
- changes the read or write location on a lob,
lo_lseek
- lo_open
- opens an existing large object,
lo_open
- lo_read
- reads bytes from a lob into a buffer,
lo_read
- lo_unlink
- removes a lob from a database,
lo_unlink
- lo_write
- writes len bytes to a lob,
lo_write
- multi-threaded / servlet environment issues,
Multi-Threaded / Servlet Environment Issues
- ODBC
- closing a connection,
Closing a Connection
- developing an application with,
Developing an Application with ODBC Functions
- driver,
The ODBC Driver
- installing,
Installing the ODBC Driver
- overview,
ODBC Interface
- on_error_continue
- allows an application to continue after errors,
Error Processing Functions
- on_error_stop
- forces an application to stop after errors,
Error Processing Functions
- Optimizer
- accessing,
Server Programming Interface
- org.largeobject,
Red Hat Database Extensions to the JDBC API
- org.postgresql,
Red Hat Database Extensions to the JDBC API
- org.postgresql.fastpath,
Red Hat Database Extensions to the JDBC API
- org.postgresql.geometric,
Red Hat Database Extensions to the JDBC API
- org.util,
Red Hat Database Extensions to the JDBC API
- Parser
- accessing,
Server Programming Interface
- Perl
- overview,
PL/Perl - Perl Procedural Language
- PGbox class,
PGbox Class
- PGcircle class,
PGcircle Class
- PGCLIENTENCODING
- sets the default client encoding,
Environment Variables
- PGconn
- represents a database connection,
Database Connection Functions
- PgConnection
- makes a connection to the database,
PgConnection
- makes the database connection,
PGConnection
- PgDatabase
- connects to a backend server,
PgDatabase
- retrieves pending notifications,
Notifies
- sets the default database name,
Environment Variables
- PgDatabase::EndCopy
- synchronizes with the backend,
EndCopy
- PgDatabase::GetLine
- reads a line of characters into a buffer ,
GetLine
- PgDatabase::PutLine
- sends a line of characters into a buffer ,
PutLine
- PGDATESTYLE
- sets the default date/time style,
Environment Variables
- pgdb.py
- Python Database API module,
Introduction
- pgeasy
- simplified C library,
libpgeasy - Simplified libpq C Library
- PGGEQO
- sets the genetic optimizer's default mode,
Environment Variables
- PGHOST
- sets the default server name,
Environment Variables
- PGline class,
PGline Class
- PGlseg class,
PGlseg Class
- PGmoney class,
PGmoney Class
- PGobject class,
PGobject Class
- PGOPTIONS
- sets runtime options for the backend,
Environment Variables
- PGPASSWORD
- sets the password,
Environment Variables
- PGpath class,
PGpath Class
- PGpoint class,
PGpoint Class
- PGpolygon class,
PGpolygon Class
- PGPORT
- sets the default port or socket,
Environment Variables
- PGREALM
- sets the Kerberos realm,
Environment Variables
- PGresult
- encapsulates a query result,
PQexec
- PGRES_POLLING_ states
- returned by PQconnectPoll,
PQconnectStart, PQconnectPoll
- pgtcl
- closing,
pg_lo_close
- connecting,
pg_connect,
pg_disconnect,
pg_conndefaults,
pg_result,
- creating,
pg_lo_creat
- delete,
pg_lo_unlink
- export,
pg_lo_export
- import,
pg_lo_import
- positioning,
pg_lo_tell
- reading,
pg_lo_read
- writing,
pg_lo_write
- PGtokenizer class,
PGtokenizer Class
- PGTTY
- sets the debugging file or tty,
Environment Variables
- PGTZ
- sets the default time zone,
Environment Variables
- PGUSER
- sets the username,
Environment Variables
- pg_conndefaults,
pg_conndefaults
- pg_connect
- connects to the backend server,
pg_connect
- pg_disconnect
- closes a connection to the backend server,
pg_disconnect
- pg_exec
- sends a query string to the server ,
pg_exec
- pg_listen
- sets a callback for NOTIFY messages,
pg_listen
- pg_lo_close
- closes a large object,
pg_lo_close
- pg_lo_creat
- creates a large object,
pg_lo_creat
- pg_lo_export
- exports a large object to a Linux file,
pg_lo_export
- pg_lo_import
- imports a lob from a Linux file,
pg_lo_import
- pg_lo_lseek
- seeks to a position in a lob,
pg_lo_lseek
- pg_lo_open
- opening,
- opens a large object,
- pg_lo_read
- reads a large object,
pg_lo_read
- pg_lo_tell
- returns the seek position of a lob,
pg_lo_tell
- pg_lo_unlink
- deletes a large object,
pg_lo_unlink
- pg_lo_write
- writes a large object,
pg_lo_write
- pg_result,
pg_result
- pg_select
- loops over SELECT results,
- PHP
- configuration,
PHP Configuration
- creating files,
Creating the PHP Files
- installation as a CGI interpreter,
Install PHP as a CGI Interpreter
- installation as an Apache module,
Install PHP as an Apache Module
- sample application,
Sample Application
- using with RHDB,
Setting Up a Web Site that Uses PHP
- verification of,
Confirm that PHP is Working Properly
- PL/Perl
- building and installing,
Building and Installing PL/Perl
- data values,
Data Values in PL/Perl
- database access,
Database Access from PL/Perl
- disabled operations,
Overview
- overview,
PL/Perl - Perl Procedural Language
- PL/pgSQL
- aborting,
Aborting and Messages
- advantages of,
Advantages of Using PL/pgSQL
- assignment,
Assignment
- calling another function,
Calling Another Function
- control structures,
Control Structures
- developing in,
Developing in PL/pgSQL
- differences from Oracle PL/SQL,
Main Differences
- escaping single quotes,
Escaping Single Quotes
- examples,
Examples
- exceptions,
Exceptions
- executing dynamic queries,
Executing Dynamic Queries
- expressions,
PL/pgSQL Expressions
- iterating through Records,
Iterating Through Records
- messages,
Aborting and Messages
- obtaining other results status,
Obtaining Other Results Status
- overview,
PL/pgSQL - SQL Procedural Language
- porting from Oracle PL/SQL,
Porting from Oracle PL/SQL
- porting functions,
Porting Functions
- procedures,
Procedures
- Record assignments,
Assignments
- Record declarations,
Declaration
- records,
Records
- returning from a function,
Returning From a Function
- rowtypes,
Rowtypes
- statements,
PL/pgSQL Statements
- trigger example,
Trigger Procedures
- trigger procedures,
Trigger Procedures
- working with Records,
Working with RECORDs
- PL/SQL
- differences from PL/pgSQL,
Main Differences
- porting from,
Porting from Oracle PL/SQL
- PL/Tcl
- data values,
Data Values in PL/Tcl
- database access,
Database Access from PL/Tcl
- functions and arguments,
PL/Tcl Functions and Arguments
- global data,
Global Data in PL/Tcl
- overview,
PL/Tcl - Tcl Procedural Language
- procedure names,
Tcl Procedure Names
- Planner
- accessing,
Server Programming Interface
- PostgreSQL
- configuration for ODBC,
Configuration of Red Hat Database
- postgresql.conf
- configuring for TCP/IP,
Configuration of Red Hat Database
- postmaster
- restarting,
Configuration of Red Hat Database
- PQbackendPID
- returns connection's process ID,
PQbackendPID
- PQbinaryTuples
- returns result's type of data,
PQbinaryTuples
- PQclear
- frees the storage associated with a query,
PQclear
- stops memory leaks from PGresult,
PQclear
- PQcmdStatus
- returns status of an SQL command,
PQcmdStatus
- PQcmdTuples
- returns number of rows affected by an SQL command,
PQcmdTuples
- PQconndefaults
- returns default connection options,
PQconndefaults
- PQconnectdb
- connects to a database,
Database Connection Functions
- makes new database connection,
PQconnectdb
- synopsis,
PQconnectdb
- PQconnectPoll
- blocks if USE_SSL defined,
PQconnectStart, PQconnectPoll
- determining state of socket for,
PQconnectStart, PQconnectPoll
- made new database connection,
PQconnectStart, PQconnectPoll
- non-blocking analog of PQconnectdb,
PQconnectdb
- synopsis,
PQconnectStart, PQconnectPoll
- PQconnectStart
- made new database connection,
PQconnectStart, PQconnectPoll
- non-blocking analog of PQconnectdb,
PQconnectdb
- synopsis,
PQconnectStart, PQconnectPoll
- PQconninfoFree()
- stops memory leaks from PQconndefaults(),
PQconndefaults
- PQconsumeInput
- consumes any input available from the backend,
PQconsumeInput
- PQdb
- returns database name of connection,
PQdb
- PQendcopy
- syncs with the backend,
PQendcopy
- PQerrorMessage
- returns connection's last error,
PQerrorMessage
- PQexec
- query RHDB,
PQexec
- shortcomings,
Asynchronous Query Processing
- PQfinish
- closes the backend connection,
PQfinish
- closes the connection to the backend,
PQfinish
- PQflush
- attempts to flush any queued data,
PQflush
- PQfmod
- returns modification data of field index,
PQfmod
- PQfn
- requests a backend function via fast path,
PQfn
- PQfname
- returns field name of field index,
PQfname
- PQfnumber
- returns field index of field name,
PQfnumber
- PQfsize
- returns size of field index,
PQfsize
- PQftype
- returns field type of field index,
PQftype
- PQgetisnull
- tests a field for a NULL entry,
PQgetisnull
- PQgetlength
- returns number of bytes in field,
PQgetlength
- PQgetline
- reads characters into a buffer,
PQgetline
- PQgetlineAsync
- reads characters into a buffer (non-blocking),
PQgetlineAsync
- PQgetResult
- awaits the next result from a PQgetResult and returns it,
PQgetResult
- basis of PQexec,
Asynchronous Query Processing
- PQgetssl
- returns connection's SSL structure,
PQgetssl
- PQgetvalue
- returns ASCII of attribute value,
PQgetvalue
- PQhost
- returns connection's server hostname,
PQhost
- PQisBusy
- returns whether a query is busy,
PQisBusy
- PQisnonblocking
- sets the connection's blocking status,
PQisnonblocking
- PQmakeEmptyPGresult
- constructs an empty PGresult object,
PQmakeEmptyPGresult
- PQnfields
- returns number of tuple's fields (attributes),
PQnfields
- PQnotifies
- returns next unhandled message,
PQnotifies
- PQntuples
- returns number of tuples (rows),
PQntuples
- PQoidValue
- returns object id of inserted tuple,
PQoidValue
- PQoptions
- returns connection's backend options,
PQoptions
- PQpass
- returns connection password,
PQpass
- PQport
- returns connection port,
PQport
- PQprint
- prints all tuples and attribute names,
PQprint
- PQputline
- sends a string to the backend server,
PQputline
- PQrequestCancel
- requests PostgreSQL abandon the current query,
PQrequestCancel
- PQreset
- resets the backend connection,
PQreset
- resets the connection to the backend,
PQreset
- PQresetPoll
- resets the backend connection (non-blocking),
PQresetStart, PQresetPoll
- PQresetStart
- resets the backend connection (non-blocking),
PQresetStart, PQresetPoll
- PQresStatus
- converts a result status into a string constant,
PQresStatus
- PQresultErrorMessage
- returns query's error,
PQresultErrorMessage
- PQresultStatus
- returns query's result status,
PQresultStatus
- PQsendQuery
- basis of PQexec,
Asynchronous Query Processing
- submits a query without awaiting the result,
PQsendQuery
- PQsetdb
- made new database connection,
PQsetdb
- PQsetdb macro,
PQsetdb
- PQsetdbLogin
- connects to a database,
Database Connection Functions
- made new database connection,
PQsetdbLogin
- synopsis,
PQsetdbLogin
- PQsetnonblocking
- sets non-blocking connection to the backend,
Asynchronous Query Processing
- sets the connection's nonblocking status,
PQsetnonblocking
- PQsetNoticeProcessor
- controls reporting of messages,
PQsetNoticeProcessor
- PQsocket
- gets the backend connection socket's file descriptor number ,
PQsocket
- PQstatus
- confirms a database connection,
Database Connection Functions
- returns connection status,
PQstatus
- PQtrace
- enables communication tracing for debugging,
PQtrace
- requires that stream objects not block,
PQconnectStart, PQconnectPoll
- PQtty
- returns connection's debug tty,
PQtty
- PQuntrace
- disables communication tracing for debugging,
PQuntrace
- PQuser
- returns user name of connection,
PQuser
- PreparedStatement interface
- using,
Notes on Using the Statement and PreparedStatement Interfaces
- Procedural Languages (PL),
Server Programming Interface
- Python
- acquiring software,
Getting and Installing Python and the Database API Code
- code samples,
Python Code Samples
- overview,
Introduction
- sample application,
Sample Application
- Python Database API
- loading,
Loading the Python Database API Module and Connecting to a Database
- overview,
The Python Database API
- performing queries, updates,
Performing Queries and Updates
- retrieving results,
Retrieving Results
- version 2.0 concepts,
Python Database API Version 2.0 Concepts
- quotes
- escaping single,
Escaping Single Quotes
- reset_fetch
- forces a fetch to the beginning,
Query Execution and Processing Functions
- ResultSet interface
- using,
Notes on Using the ResultSet Interface
- Serializable interface,
Serializable Interface
- Server Programming Interface (SPI)
- overview,
Server Programming Interface
- SetNoticeProcessor
- retrieves pending notifications,
SetNoticeProcessor
- set_result
- sets the current internal result set,
Query Execution and Processing Functions
- single quotes
- escaping,
Escaping Single Quotes
- socket
- determining state of,
PQconnectStart, PQconnectPoll
- SPI
- allocating space,
SPI_palloc,
SPI_repalloc,
SPI_pfree
- connecting,
SPI_connect,
SPI_prepare,
SPI_saveplan
- copying tuples,
SPI_copytuple
- decoding tuples,
SPI_fnumber,
SPI_fname,
SPI_getvalue,
SPI_getbinval,
SPI_gettype,
SPI_gettypeid,
SPI_getrelname
- disconnecting,
SPI_finish
- executing,
SPI_exec
- memory management,
Memory Management
- modifying tuples,
SPI_modifytuple
- overview,
Server Programming Interface
- SPI_connect
- connects a procedure to the SPI manager,
SPI_connect
- SPI_copytuple
- makes copy of tuple in upper Executor context,
SPI_copytuple
- SPI_exec
- creates a plan and executes a query,
SPI_exec
- SPI_execp
- executes a plan from SPI_saveplan,
SPI_execp
- SPI_finish
- disconnects a procedure from the SPI manager,
SPI_finish
- SPI_fname
- finds the attribute name of an attribute,
SPI_fname
- SPI_fnumber
- finds the attribute number of an attribute,
SPI_fnumber
- SPI_getbinval
- returns the binary value of an attribute,
SPI_getbinval
- SPI_getrelname
- returns the name of a relation,
SPI_getrelname
- SPI_gettype
- returns the type name of an attribute,
SPI_gettype
- SPI_gettypeid
- returns the type OID of an attribute,
SPI_gettypeid
- SPI_getvalue
- returns the string value of an attribute,
SPI_getvalue
- SPI_modifytuple
- modifies tuple of relation,
SPI_modifytuple
- SPI_palloc
- allocates memory in upper Executor context,
SPI_palloc
- SPI_pfree
- frees memory from upper Executor context,
SPI_pfree
- SPI_prepare
- connects a procedure to the SPI manager,
SPI_prepare
- SPI_repalloc
- re-allocates memory in upper Executor context,
SPI_repalloc
- SPI_saveplan
- saves a passed plan,
SPI_saveplan
- SQL commands
- in embedded SQL,
SQL Commands
- Statement interface
- using,
Notes on Using the Statement and PreparedStatement Interfaces
- Status
- returns the status of the database connection,
Status
- trigger manager,
Interaction with the Trigger Manager
- triggers,
Triggers
- Tuples
- returns the number of rows,
Tuples
- UnixCrypt class,
UnixCrypt Class
- unset_result
- unsets the last internal result set,
Query Execution and Processing Functions
- updates
- performing with Statement,
Performing Updates