Filewatcher File Search File Search
Content Search
» » » » »


additional facilities for PostgreSQL

The PostgreSQL contrib package provides several additional features for the PostgreSQL database. This version is built to work with the server package postgresql-7.4. contrib often serves as a testbed for features before they are adopted into PostgreSQL proper:

adddepend - Process databases upgraded from PostgreSQL 7.2 and earlier to add dependency information that 7.3+ creates from the start array - Array iterator functions btree_gist - B-Tree indexing using GiST (Generalised Search Tree) chkpass - Password type for storing and comparing encrypted passwords cube - Type for n-dimensional "cubes" dbase - Inserts the contents of an xBase-style .dbf file into a PostgreSQL table dblink - Functions to return results from a remote database dbmirror - Trigger-based databaase mirroring dbsize - Report filesystem space used by a database earthdistance - Operator for computing the distance (in miles) between two points on the earth's surface findoidjoins - Finds the joins used by oid columns by examining the actual values in the oid columns and row oids. fulltextindex - Full text indexing using triggers fuzzystrmatch - Functions for fuzzy string comparison (including Soundex) intagg - Integer aggregator/enumerator intarray - RD-tree data structure using GiST index isbn_issn - Type extensions for ISBN (books) and ISSN (serials) lo - Large Object maintenance ltree - data types, indexed access methods and queries for data organized as a tree-like structures. mac - Maps MAC addresses to manufacture names miscutil - Some utility functions mysql - Conversion utilities for MySQL dumps noupdate - Trigger to prevent updates on single columns oid2name - Maps oids to table names oracle - Conversion utility for Oracle database schemas pg_autovacuum - Automatic tidying of deleted tuples in the background. pg_dumplo - Large Object dumper pg_logger - Stdin to syslog gateway pg_upgrade - Migrate 7.1 database for initdb without requiring a full dump and reload. Experimental! pgbench - A simple program to run a benchmark test pgcrypto - Cryptographic functions pgstattuple - Returns the percentage of dead tuples in a table; this indicates whether a vacuum is required. reindexdb - Script to destroy and rebuild indexes, thus reclaiming space that vacuum does not reclaim retep - Java utilities for use with JDBC rserv - Database replication rtree_gist - R-Tree indexing using Generalised Search Tree algorithms seg - Type representing laboratory measurements as floating- point intervals spi - PostgreSQL Server Programming Interface; 4 examples of its use: autoinc - A function for implementing AUTOINCREMENT/ IDENTITY insert_username - function for inserting user names moddatetime - Update modification timestamps refint - Functions for implementing referential integrity (foreign keys). Note that this is now superseded by built-in referential integrity. timetravel - Re-implements in user code the time travel feature that was removed in 6.3. string - C-like input/output conversion routines for strings tablefunc - C functions which return setof scalar and setof composite tips - Micro HOWTOs tsearch - Searchable text data type supporting indexed access tsearch2 - Searchable text data type supporting indexed access userlock - User-level long-term locks vacuumlo - Vacuum deleted large objects xml - Manipulate XML documents in the database

PostgreSQL is an object-relational SQL database management system.

Package version:1:7.4.27-0etch1


PostgreSQL Database Management System
This directory contains the source code distribution of the PostgreSQL
database management system.

PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, user-defined types
and functions.  T


HOW TO get Apache to log to PostgreSQL

 Note: contain of files 'httpconf.txt' and 'apachelog.sql' are below this

First, this is intended mostly as a starting point, an example of how to do it.

The file 'httpconf.txt' is commented and contains two example lines to make
this work, a custom log format, and a line that sends the log data to psq


This is B-Tree implementation using GiST for int2, int4, int8, float4, float8
timestamp types.

All work was done by Teodor Sigaev ( and Oleg Bartunov
( See
for additional information.

     Feb 5, 2003 - btree_gist now support int2, int8, float4, float8 !
                   Thank Janko Richter <jankorichter@yahoo.


$Header: /cvsroot/pgsql/contrib/chkpass/Attic/README.chkpass,v 1.1 2001/05/03 12:32:13 darcy Exp $



This directory contains the code for the user-defined type,
CUBE, representing multidimensional cube


dbf2sql(1L)					      dbf2sql(1L)

       dbf2sql	-  Insert  xBase-style	.dbf-files  into  


 * dblink
 * Functions returning results from a remote database
 * Joe Conway <mail@joeconw


DBMirror - PostgreSQL Database Mirroring


Browse inside postgresql-contrib-7.4_7.4.27-0etch1_amd64.deb

         [DIR]DEBIAN/ (4)  65535+ mirrors
         [DIR]usr/ (2)  65535+ mirrors

Download postgresql-contrib-7.4_7.4.27-0etch1_amd64.deb

Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2016