6 cd /INTERNET/suse72/dvd/
8 rpm -Uvh postgresql.rpm
10 rpm -Uvh postgresql-lib.rpm
11 rpm -Uvh postgresql-server.rpm
12 rpm -Uvh postgresql-devel.rpm
18 -> export PGDATA=/var/lib/pgsql/data
23 /etc/rc.d/postgresql start
26 createdb OpenGroupware
30 > add line: "host all 192.168.0.1 255.255.255.0 trust"
33 /etc/rc.d/postgresql restart
42 Querying the tables of a database
43 ---------------------------------
47 WHERE ( relkind = 'r') AND relname !~ '^pg_'
48 AND relname !~ '^xinv[0-9]+'
51 und die infos dazu mit:
53 SELECT a.attnum, a.attname, t.typname, a.attlen, a.attnotnull
54 FROM pg_class c, pg_attribute a, pg_type t
55 WHERE c.relname = 'TABELLENNAME_HERE' AND
56 a.attnum > 0 AND a.attrelid = c.oid
57 AND a.atttypid = t.oid
60 Quering the databases of a server
61 ---------------------------------
63 SELECT * FROM pg_database
65 You need a database to connect PostgreSQL using libpq, but 'template1' should
68 Fetch DB-names and their DBA:
69 SELECT DISTINCT dbs.datname, users.usename
70 FROM pg_database dbs, pg_user users
71 WHERE dbs.datdba=users.usesysid