PostgreSQL - Tipps und Tricks: Unterschied zwischen den Versionen
Aus Geoinformation HSR
Stefan (Diskussion | Beiträge) |
Stefan (Diskussion | Beiträge) |
||
Zeile 12: | Zeile 12: | ||
== PostgreSQL SQL == | == PostgreSQL SQL == | ||
− | + | Version: | |
+ | select version(); | ||
+ | |||
+ | Problem with date fields (works for < 8.3): | ||
+ | SELECT THE_GEOM ... (END_DATE - NOW() >= 10) AS GREEN | ||
+ | AND (END_DATE - NOW() < 0) AS RED ... FROM ... | ||
+ | Casting changes in 8.3: | ||
+ | SELECT THE_GEOM ... (END_DATE - NOW() >= '10 DAYS'::INTERVAL) AS GREEN | ||
+ | AND (END_DATE - NOW() < '0'::INTERVAL) AS RED ... FROM ... | ||
+ | |||
== Konfiguration == | == Konfiguration == | ||
Version vom 3. Dezember 2008, 02:08 Uhr
Siehe auch:
Quickreference
Im Aufbau...
- Start pgsl-Client:
$ psql.exe -h localhost -p 5432 template1 "postgres"
PostgreSQL SQL
Version:
select version();
Problem with date fields (works for < 8.3):
SELECT THE_GEOM ... (END_DATE - NOW() >= 10) AS GREEN AND (END_DATE - NOW() < 0) AS RED ... FROM ...
Casting changes in 8.3:
SELECT THE_GEOM ... (END_DATE - NOW() >= '10 DAYS'::INTERVAL) AS GREEN AND (END_DATE - NOW() < '0'::INTERVAL) AS RED ... FROM ...
Konfiguration
Die pg_hba.conf kann so eingestellt werden, dass bei der Ausführung von PostgreSQL-Kommandozeilen-Tools kein Passwort übertragen werden muss.
Bsp mit 127.0.0.1: Anstelle
# IPv4 local connections: host all all 127.0.0.1/32 md5
neu:
# IPv4 local connections: host all all 127.0.0.1/32 trust