SISU - SEARCH,
RALPH AMISSAH
*****************************

SISU SEARCH
===========

SISU POSTGRESQL
===============

1. POSTGRESQL
-------------

1.1 NAME
........

*SiSU* - Structured information, Serialized Units - a document publishing
system, postgresql dependency package


1.2 DESCRIPTION
...............

Information related to using postgresql with sisu (and related to the
sisu_postgresql dependency package, which is a dummy package to install
dependencies needed for *SiSU* to populate a postgresql database, this being
part of *SiSU* - man sisu).


1.3 SYNOPSIS
............

  sisu -D [instruction] [filename/wildcard if required]


  sisu -D --pg --[instruction] [filename/wildcard if required]


1.4 COMMANDS
............

Mappings to two databases are provided by default, postgresql and sqlite, the
same commands are used within sisu to construct and populate databases however
-d (lowercase) denotes sqlite and -D (uppercase) denotes postgresql,
alternatively --sqlite or --pgsql may be used


*-D or --pgsql* may be used interchangeably.


1.4.1 CREATE AND DESTROY DATABASE
.................................

*--pgsql --createall*
initial step, creates required relations (tables, indexes) in existing
(postgresql) database (a database should be created manually and given the same
name as working directory, as requested) (rb.dbi)


*sisu -D --createdb*
creates database where no database existed before


*sisu -D --create*
creates database tables where no database tables existed before


*sisu -D --Dropall*
destroys database (including all its content)! kills data and drops tables,
indexes and database associated with a given directory (and directories of the
same name).


*sisu -D --recreate*
destroys existing database and builds a new empty database structure


1.4.2 IMPORT AND REMOVE DOCUMENTS
.................................

*sisu -D --import -v [filename/wildcard]*
populates database with the contents of the file. Imports documents(s)
specified to a postgresql database (at an object level).


*sisu -D --update -v [filename/wildcard]*
updates file contents in database


*sisu -D --remove -v [filename/wildcard]*
removes specified document from postgresql database.


DOCUMENT INFORMATION (METADATA)
*******************************

METADATA
--------

Document Manifest @
<http://www.jus.uio.no/sisu/sisu_manual/sisu_postgresql/sisu_manifest.html>


*Dublin Core* (DC)


/DC tags included with this document are provided here./


DC Title: _SiSU - Search_


DC Creator: _Ralph Amissah_


DC Rights: _Copyright (C) Ralph Amissah 2007, part of SiSU documentation,
License GPL 3_


DC Type: _information_


DC Date created: _2002-08-28_


DC Date issued: _2002-08-28_


DC Date available: _2002-08-28_


DC Date modified: _2007-09-16_


DC Date: _2007-09-16_


*Version Information*


Sourcefile: _sisu_postgresql.sst_


Filetype: _SiSU text 0.58_


Sourcefile Digest, MD5(sisu_postgresql.sst)= _5f9ca1acb186a64f8e924876892dc25e_


Skin_Digest:
MD5(/home/ralph/grotto/theatre/dbld/builds/sisu/sisu/data/doc/sisu/sisu_markup_samples/sisu_manual/_sisu/skin/doc/skin_sisu_manual.rb)=
_20fc43cf3eb6590bc3399a1aef65c5a9_


*Generated*


Document (metaverse) last generated: _Tue Sep 25 02:54:21 +0100 2007_


Generated by: _SiSU_ _0.59.1_ of 2007w39/2 (2007-09-25)


Ruby version: _ ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]_



==============================================================================

	title:  SiSU - Search

	creator:  Ralph Amissah

	rights:  Copyright (C) Ralph Amissah 2007, part of SiSU documentation,
               License GPL 3

	type:  information

	subject:  ebook, epublishing, electronic book, electronic publishing,
               electronic document, electronic citation, data structure,
               citation systems, search

	date.created:  2002-08-28

	date.issued:  2002-08-28

	date.available:  2002-08-28

	date.modified:  2007-09-16

	date:  2007-09-16





==============================================================================
nil

Other versions of this document:
manifest:
   http://www.jus.uio.no/sisu/sisu_postgresql/sisu_manifest.html
html:
   http://www.jus.uio.no/sisu/sisu_postgresql/toc.html
pdf:
   http://www.jus.uio.no/sisu/sisu_postgresql/portrait.pdf
   http://www.jus.uio.no/sisu/sisu_postgresql/landscape.pdf
plaintext (plain text):
   http://www.jus.uio.no/sisu/sisu_postgresql/plain.txt
at:
   http://www.jus.uio.no/sisu
* Generated by: SiSU 0.59.1 of 2007w39/2 (2007-09-25)
* Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]
* Last Generated on: Tue Sep 25 02:54:21 +0100 2007
* SiSU http://www.jus.uio.no/sisu