Name | Date | Size | #Lines | LOC | ||
---|---|---|---|---|---|---|
.. | 16-Dec-2021 | - | ||||
COPYING | H A D | 16-Dec-2021 | 17.6 KiB | 340 | 281 | |
ChangeLog | H A D | 16-Dec-2021 | 11.8 KiB | 386 | 225 | |
EOAttribute+PostgreSQL72.h | H A D | 16-Dec-2021 | 1.5 KiB | 47 | 13 | |
EOAttribute+PostgreSQL72.m | H A D | 16-Dec-2021 | 7 KiB | 228 | 209 | |
EOKeyGlobalID+PGVal.m | H A D | 16-Dec-2021 | 1.5 KiB | 46 | 34 | |
GNUmakefile | H A D | 16-Dec-2021 | 1.9 KiB | 73 | 34 | |
GNUmakefile.preamble | H A D | 16-Dec-2021 | 2.3 KiB | 91 | 69 | |
NSCalendarDate+PGVal.m | H A D | 16-Dec-2021 | 6.3 KiB | 220 | 186 | |
NSData+PGVal.m | H A D | 16-Dec-2021 | 3.6 KiB | 123 | 102 | |
NSNull+PGVal.m | H A D | 16-Dec-2021 | 1.2 KiB | 38 | 27 | |
NSNumber+ExprValue.m | H A D | 16-Dec-2021 | 1.5 KiB | 50 | 34 | |
NSNumber+PGVal.m | H A D | 16-Dec-2021 | 5 KiB | 181 | 153 | |
NSString+PGVal.m | H A D | 16-Dec-2021 | 4 KiB | 142 | 118 | |
NSString+PostgreSQL72.h | H A D | 16-Dec-2021 | 1.3 KiB | 41 | 10 | |
NSString+PostgreSQL72.m | H A D | 16-Dec-2021 | 4.4 KiB | 174 | 133 | |
PGConnection.h | H A D | 16-Dec-2021 | 3.1 KiB | 130 | 56 | |
PGConnection.m | H A D | 16-Dec-2021 | 5.6 KiB | 223 | 169 | |
PGResultSet.m | H A D | 16-Dec-2021 | 3.5 KiB | 149 | 116 | |
PostgreSQL-Info.plist | H A D | 16-Dec-2021 | 578 | 19 | 18 | |
PostgreSQL72Adaptor.h | H A D | 16-Dec-2021 | 2.2 KiB | 89 | 26 | |
PostgreSQL72Adaptor.m | H A D | 16-Dec-2021 | 4.5 KiB | 181 | 142 | |
PostgreSQL72Channel+Model.h | H A D | 16-Dec-2021 | 1.4 KiB | 45 | 12 | |
PostgreSQL72Channel+Model.m | H A D | 16-Dec-2021 | 12.5 KiB | 367 | 297 | |
PostgreSQL72Channel.h | H A D | 16-Dec-2021 | 2.3 KiB | 85 | 40 | |
PostgreSQL72Channel.m | H A D | 16-Dec-2021 | 22.2 KiB | 789 | 625 | |
PostgreSQL72Context.h | H A D | 16-Dec-2021 | 1.2 KiB | 40 | 9 | |
PostgreSQL72Context.m | H A D | 16-Dec-2021 | 2.7 KiB | 99 | 73 | |
PostgreSQL72DataTypeMappingException.m | H A D | 16-Dec-2021 | 2.6 KiB | 79 | 60 | |
PostgreSQL72Exception.h | H A D | 16-Dec-2021 | 1.4 KiB | 55 | 21 | |
PostgreSQL72Exception.m | H A D | 16-Dec-2021 | 1.7 KiB | 63 | 45 | |
PostgreSQL72Expression.h | H A D | 16-Dec-2021 | 1.5 KiB | 56 | 20 | |
PostgreSQL72Expression.m | H A D | 16-Dec-2021 | 2.9 KiB | 100 | 75 | |
PostgreSQL72Values.h | H A D | 16-Dec-2021 | 2.4 KiB | 87 | 37 | |
README | H A D | 16-Dec-2021 | 1.5 KiB | 72 | 52 | |
TODO | H A D | 16-Dec-2021 | 78 | 4 | 3 | |
Version | H A D | 16-Dec-2021 | 78 | 6 | 3 | |
common.h | H A D | 16-Dec-2021 | 1.3 KiB | 42 | 11 | |
condict.plist | H A D | 16-Dec-2021 | 142 | 8 | 7 | |
fhs.make | H A D | 16-Dec-2021 | 661 | 26 | 17 | |
gdltest.m | H A D | 16-Dec-2021 | 5.1 KiB | 190 | 148 | |
pgconfig.h | H A D | 16-Dec-2021 | 1.6 KiB | 52 | 15 | |
postgres_types.h | H A D | 16-Dec-2021 | 1 KiB | 47 | 45 | |
test.eomodel | H A D | 16-Dec-2021 | 641 | 26 | 24 | |
types.psql | H A D | 16-Dec-2021 | 276 | 14 | 11 |
README
1PostgreSQL Adaptor 2================== 3 4Install PostgreSQL: 5 6 cd /INTERNET/suse72/dvd/ 7 cd ap3 8 rpm -Uvh postgresql.rpm 9 cd ap2 10 rpm -Uvh postgresql-lib.rpm 11 rpm -Uvh postgresql-server.rpm 12 rpm -Uvh postgresql-devel.rpm 13 14Configure PostgreSQL: 15 16 su - postgres 17 vi .bashrc 18 -> export PGDATA=/var/lib/pgsql/data 19 source .bashrc 20 initdb 21 22 su - root 23 /etc/rc.d/postgresql start 24 25 su - postgres 26 createdb OpenGroupware 27 createuser ogo 28 29 vi data/pg_hba.conf 30 > add line: "host all 192.168.0.1 255.255.255.0 trust" 31 32PostgreSQL starten: 33 /etc/rc.d/postgresql restart 34 35Configure the Adaptor 36 PGDebugEnabled 37 38 39NOTES 40===== 41 42Querying the tables of a database 43--------------------------------- 44 45SELECT relname 46 FROM pg_class 47 WHERE ( relkind = 'r') AND relname !~ '^pg_' 48 AND relname !~ '^xinv[0-9]+' 49 ORDER BY relname; 50 51und die infos dazu mit: 52 53SELECT 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 58 ORDER BY attnum; 59 60Quering the databases of a server 61--------------------------------- 62 63 SELECT * FROM pg_database 64 65You need a database to connect PostgreSQL using libpq, but 'template1' should 66always be available. 67 68Fetch 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 72