PostgreSQL (2nd Edition)

 
[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]

RAISE

       PL/pgSQL   2nd   3rd  

RAISE DEBUG  

RAISE EXCEPTION  

RAISE NOTICE  

RaiseError

       Perl  

RANDOM PAGE COST  

raw data  

READ COMMITTED isolation level  

read history()  

readline library   2nd  

readline() function  

readline() method (JDBC)  

recalls table   2nd  

        reordering   2nd   3rd   4th  

RECORD

       FETCH  

record id index  

records

       adding to tables

               COPY command   2nd   3rd  

               INSERT command   2nd   3rd   4th   5th   6th  

records.   [See rows]

Red Hat Package Manager.   [See RPM]

REFERENCES

       column constraints   2nd   3rd   4th   5th  

references

       cursor references

               PL/pgSQL   2nd   3rd   4th   5th   6th   7th   8th   9th  

REFERENCES

       table constraints   2nd  

REFERENCES privilege  

referent  

referents

       deleting  

regular expressions

       matching patterns   2nd   3rd  

REINDEX  

reject authentication method

       securing network access   2nd   3rd  

relational databases  

relationships

       between clusters, databases, and tables   2nd  

       between tables

               column constraints  

       performance relationships  

relative paths

       PHP  

reliable

       definition of  

removing

       dead tuples  

       groups

               DROP GROUP  

       large-objects

               BYTEA  

        user accounts  

removing.   [See also deleting]

RENAME

       PL/pgSQL  

rental cursor  

reordering

       recalls table   2nd   3rd   4th  

requirements

       for JDBC sample applications   2nd  

reset fetch()  

resetting

       SEQUENCE  

restarting

        postmaster   2nd   3rd  

restoring

       databases

               pg restore   2nd  

       hard drives

               administrator's roles   2nd  

RESTRICT   2nd  

Result operator   2nd  

result set processing.   [See queries]

result sets   2nd  

       binding columns  

       definition of  

       libpgeasy   2nd  

       metadata  

       printing

               in libpq  

       processing in Perl  

               fetchrow array()  

               fetchrow arrayref()   2nd   3rd   4th   5th  

               fetchrow hashref()   2nd   3rd  

               pad()   2nd  

               print column headings()  

               print results()   2nd  

       processing multiple result sets

               libpq   2nd   3rd   4th  

       retrieving

               in Python   2nd  

               PgConnection object  

       retrieving with PHP  

results

       client applications  

       fetching  

       formatting

               with dump results()  

       grouping

               aggregate functions   2nd   3rd   4th   5th   6th  

       loading into widgets

               in Python  

       processing

               ODBC interactive query processors   2nd   3rd   4th   5th   6th  

results sets

       fields versus columns  

ResultSet class (JDBC)   2nd  

        methods for   2nd  

ResultSetMetaData interface (JDBC)  

retreiving

       result sets from cursors

               FETCH   2nd   3rd   4th   5th   6th  

retrieving

       column count

               ecpg  

       data from tables   2nd  

               matching patterns.   [See matching patterns]

               SELECT   2nd  

               SELECT * FROM   2nd  

               SELECT column-list FROM  

               SELECT expression-list FROM  

               SELECT single-column FROM  

               selecting specific rows.   [See selecting, specific rows]

       data sources   2nd   3rd  

       error message text

               libpq++  

       error messages

               ODBC  

               SQLError()  

       result set values

               PHP  

       result sets

               PgConnection object  

retrieving result sets

       in Python   2nd  

RETURN

       PL/pgSQL   2nd  

returning

       multiple values from extension functions   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  

reusable Tcl code

       sharing   2nd   3rd  

REVOKE  

revoking

       access to user accounts  

       user privileges

               ODBC  

right-shift operators (  

ROLLBACK  

ROLLBACK command   2nd  

rollbacks

       definition of  

root

       indexes  

root window (Tcl)

        withdrawing  

rotating

       geometric data types  

ROWID  

rows

       definition of  

       deleting  

       selecting specific rows  

               DISTINCT   2nd  

               DISTINCT ON  

               LIMIT   2nd  

               NULL values   2nd   3rd   4th   5th   6th   7th  

               OFFSET  

               ORDER BY   2nd   3rd   4th  

               WHERE   2nd   3rd  

       updating  

RPM

       installing PostgreSQL   2nd   3rd   4th   5th   6th   7th   8th  

RPM (Red Hat Package Manager)  

rpm command  

rpmfind utility  

runlevels

       Linux  

runtime

       loading JDBC drivers at  

runtime environement

       permanent configuration options  

runtime environment   2nd  

       connection- related parameters  

               HOSTNAME LOOKUP  

               KRB SERVER KEYFILE  

               MAX CONNECTIONS  

               PORT  

               SHOW SOURCE PORT  

               SSL  

               TCPIP SOCKET  

               UNIX SOCKET DIRECTORY  

               UNIX SOCKET GROUP  

               UNIX SOCKET PERMISSIONS  

               VIRTUAL HOST  

       debugging/logging parameters  

               DEBUG DEADLOCKS  

               DEBUG LEVEL  

               DEBUG PRETTY PRINT  

               DEBUG PRINT PARSE  

               DEBUG PRINT PLAN  

               DEBUG PRINT QUERY  

               DEBUG PRINT REWRITTEN  

               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 USERLOCKS  

       miscellaneous parameters  

               AUSTRALIAN TIMEZONES  

               AUTHENTICATION TIMEOUT  

               DEFAULT TRANSACTION ISOLATION  

               DYNAMIC LIBRARY PATH  

               MAX EXPR DEPTH  

               MAX FILES PER PROCESS  

               PASSWORD ENCRYPTION  

               SQL INHERITANCE  

               TRANSFORM NULL EQUALS  

       operational parameters  

               CHECKPOINT SEGMENTS  

               CHECKPOINT TIMEOUT  

               COMMIT DELAY  

               COMMIT SIBLINGS  

               FSYNC  

               MAX FSM PAGES  

               MAX FSM RELATIONS  

               MAX LOCKS PER TRANSACTION  

               SHARED BUFFERS  

               SORT MEM  

               VACUUM MEM  

               WAL BUFFERS  

               WAL FILES  

               WAL SYNC METHOD  

       optimizer parameters  

               CPU INDEX TUPLE COST  

               CPU OPERATOR COST  

               CPU TUPLE COST  

               EFFECTIVE CACHE SIZE  

               ENABLE HASHJOIN  

               ENABLE INDEXSCAN  

               ENABLE MERGEJOIN  

               ENABLE NESTLOOP  

               ENABLE SEQSCAN  

               ENABLE SORT  

               ENABLE TIDSCAN  

               GEQO  

               GEQO EFFORT  

               GEQO GENERATIONS  

               GEQO POOL SIZE  

               GEQO RANDOM SEED  

               GEQO SELECTION BIAS  

               GEQO THRESHOLD  

               KSQO  

               RANDOM PAGE COST  

       parameters

               SIGHUP  

       performace statistics  

               SHOW BTREE BUILD STATS  

               SHOW EXECUTOR STATS  

               SHOW PARSER STATS  

               SHOW QUERY STATS  

               STATS BLOCK LEVEL  

               STATS COMMAND STRING  

               STATS RESET ON SERVER START  

               STATS ROW LEVEL  

               STATS START COLLECTOR  

runtime errors

       ecpg  

 

Категории