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 @ *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