Red Hat Database: Programmer's Guide
Prev 

Index

A

access information file (ODBC), Access Information File
Apache
starting or restarting, Start or Restart the Apache Server

C

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

D

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
dynamic_library_path, Dynamic Loading

E

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
escaping binary strings, Escaping Binary Strings for Inclusion in SQL Queries
escaping strings, Escaping Strings for Inclusion in SQL Queries
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 (SPI)

F

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

G

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

J

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

K

Kerberos authentication
requires a hostname, PQconnectdb

L

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

M

multi-threaded / servlet environment issues, Multi-Threaded / Servlet Environment Issues

O

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
OidStatus, OidStatus
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 (SPI)
Oracle
porting from, Porting from Oracle PL/SQL
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

P

Parser
accessing, Server Programming Interface (SPI)
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, pg_select
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, pg_lo_open
opens a large object, pg_lo_open
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
gets information about a query result, pg_result
pg_select
loops over SELECT results, pg_select
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, PL/pgSQL - SQL Procedural Language
advantages of, Advantages of Using PL/pgSQL
assignment, Assignment
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
obtaining other results status, Obtaining Result Status
overview, PL/pgSQL - SQL Procedural Language
porting from Oracle PL/SQL, Porting from Oracle PL/SQL
porting functions, Porting Functions
records, Records
returning from a function, Returning From a Function
rowtypes, Rowtypes
statements, Basic Statements
trigger example, Trigger Procedures
trigger procedures, Trigger Procedures
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 (SPI)
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 (SPI)
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

Q

quotes
escaping single, Escaping Single Quotes

R

reset_fetch
forces a fetch index to the beginning, Query Execution and Processing Functions
ResultSet interface
using, Notes on Using the ResultSet Interface

S

Serializable interface, Serializable Interface
Server Programming Interface (SPI)
overview, Server Programming Interface (SPI)
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)
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

T

trigger manager, Interaction with the Trigger Manager
triggers, Triggers
Tuples
returns the number of rows, Tuples

U

UnixCrypt class, UnixCrypt Class
unset_result
unsets the last internal result set, Query Execution and Processing Functions
updates
performing with Statement, Performing Updates
PrevHome 
Description