.TH "sisu_postgresql" "1" "2007-09-16" "0.58.3" "SiSU - SiSU information Structuring Universe" .SH SISU \- SISU INFORMATION STRUCTURING UNIVERSE \- SEARCH \ [0.58], 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 \- SiSU information Structuring Universe \- Search \ [0.58] .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 b81ba44e7946dfaf03d26f0dc5d749ab .BR Skin_Digest: MD5(/home/ralph/grotto/theatre/dbld/sisu\-dev/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 Sun Sep 23 01:14:03 +0100 2007 .BR Generated by: .I SiSU .I 0.58.3 of 2007w36/4 (2007\-09\-06) .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.58.3 of 2007w36/4 (2007-09-06) .TP * Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux] .TP * Last Generated on: Sun Sep 23 01:14:07 +0100 2007 .TP * SiSU http://www.jus.uio.no/sisu