.TH "sisu_postgresql" "1" "2007-09-16" "0.59.1" "SiSU"
.SH
SISU \- SEARCH,
RALPH AMISSAH
.BR

.SH
SISU SEARCH
.BR

.SH
SISU POSTGRESQL
.BR

.SH
1. POSTGRESQL
.BR

.SH
1.1 NAME

.BR
.B SiSU
\- Structured information, Serialized Units \- a document publishing system,
postgresql dependency package

.SH
1.2 DESCRIPTION

.BR
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
.B SiSU
to populate a postgresql database, this being part of
.B SiSU
\- man sisu).

.SH
1.3 SYNOPSIS

.BR
  sisu \-D \ [instruction] \ [filename/wildcard \ if \ required]

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

.SH
1.4 COMMANDS

.BR
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

.BR
.B \-D or \-\-pgsql
may be used interchangeably.

.SH
1.4.1 CREATE AND DESTROY DATABASE

.TP
.B \ \-\-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) \

.TP
.B \ sisu \ \-D \ \-\-createdb
\ creates \ database \ where \ no \ database \ existed \ before \

.TP
.B \ sisu \ \-D \ \-\-create
\ creates \ database \ tables \ where \ no \ database \ tables \ existed \
before \

.TP
.B \ 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). \

.TP
.B \ sisu \ \-D \ \-\-recreate
\ destroys \ existing \ database \ and \ builds \ a \ new \ empty \ database
\ structure \

.SH
1.4.2 IMPORT AND REMOVE DOCUMENTS

.TP
.B \ 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).

.TP
.B \ sisu \ \-D \ \-\-update \ \-v \ \ [filename/wildcard]
updates file contents in database

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

.SH
DOCUMENT INFORMATION (METADATA)
.BR

.SH
METADATA
.BR

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

.BR
.B Dublin Core
(DC)

.BR
.I DC tags included with this document are provided here.

.BR
DC Title:
.I SiSU \- Search

.BR
DC Creator:
.I Ralph Amissah

.BR
DC Rights:
.I Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL
3

.BR
DC Type:
.I information

.BR
DC Date created:
.I 2002\-08\-28

.BR
DC Date issued:
.I 2002\-08\-28

.BR
DC Date available:
.I 2002\-08\-28

.BR
DC Date modified:
.I 2007\-09\-16

.BR
DC Date:
.I 2007\-09\-16

.BR
.B Version Information

.BR
Sourcefile:
.I sisu_postgresql.sst

.BR
Filetype:
.I SiSU text 0.58

.BR
Sourcefile Digest, MD5(sisu_postgresql.sst)=
.I 5f9ca1acb186a64f8e924876892dc25e

.BR
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)=
.I 20fc43cf3eb6590bc3399a1aef65c5a9

.BR
.B Generated

.BR
Document (metaverse) last generated:
.I Tue Sep 25 02:54:47 +0100 2007

.BR
Generated by:
.I SiSU
.I 0.59.1
of 2007w39/2 (2007\-09\-25)

.BR
Ruby version:
.I ruby 1.8.6 (2007\-06\-07 patchlevel 36) \ [i486\-linux]


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