1 # $Id: README 1 2004-08-20 10:38:46Z znek $
5 cd /INTERNET/suse72/dvd/
7 rpm -Uvh postgresql.rpm
9 rpm -Uvh postgresql-lib.rpm
10 rpm -Uvh postgresql-server.rpm
11 rpm -Uvh postgresql-devel.rpm
17 -> export PGDATA=/var/lib/pgsql/data
22 /etc/rc.d/postgresql start
25 createdb OpenGroupware
29 > add line: "host all 192.168.0.1 255.255.255.0 trust"
32 /etc/rc.d/postgresql restart
41 Querying the tables of a database
42 ---------------------------------
46 WHERE ( relkind = 'r') AND relname !~ '^pg_'
47 AND relname !~ '^xinv[0-9]+'
50 und die infos dazu mit:
52 SELECT a.attnum, a.attname, t.typname, a.attlen, a.attnotnull
53 FROM pg_class c, pg_attribute a, pg_type t
54 WHERE c.relname = 'TABELLENNAME_HERE' AND
55 a.attnum > 0 AND a.attrelid = c.oid
56 AND a.atttypid = t.oid
59 Quering the databases of a server
60 ---------------------------------
62 SELECT * FROM pg_database
64 You need a database to connect PostgreSQL using libpq, but 'template1' should
67 Fetch DB-names and their DBA:
68 SELECT DISTINCT dbs.datname, users.usename
69 FROM pg_database dbs, pg_user users
70 WHERE dbs.datdba=users.usesysid