# $Id: README 1 2004-08-20 10:38:46Z znek $ Install PostgreSQL: cd /INTERNET/suse72/dvd/ cd ap3 rpm -Uvh postgresql.rpm cd ap2 rpm -Uvh postgresql-lib.rpm rpm -Uvh postgresql-server.rpm rpm -Uvh postgresql-devel.rpm Configure PostgreSQL: su - postgres vi .bashrc -> export PGDATA=/var/lib/pgsql/data source .bashrc initdb su - root /etc/rc.d/postgresql start su - postgres createdb OpenGroupware createuser ogo vi data/pg_hba.conf > add line: "host all 192.168.0.1 255.255.255.0 trust" PostgreSQL starten: /etc/rc.d/postgresql restart Configure the Adaptor PGDebugEnabled NOTES ===== Querying the tables of a database --------------------------------- SELECT relname FROM pg_class WHERE ( relkind = 'r') AND relname !~ '^pg_' AND relname !~ '^xinv[0-9]+' ORDER BY relname; und die infos dazu mit: SELECT a.attnum, a.attname, t.typname, a.attlen, a.attnotnull FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = 'TABELLENNAME_HERE' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY attnum; Quering the databases of a server --------------------------------- SELECT * FROM pg_database You need a database to connect PostgreSQL using libpq, but 'template1' should always be available. Fetch DB-names and their DBA: SELECT DISTINCT dbs.datname, users.usename FROM pg_database dbs, pg_user users WHERE dbs.datdba=users.usesysid