[SQL] to_timestamp, problem

000512144548', 'MMDDHHMISS'); to_timestamp -- invalid (1 row) pg 7.0.3, linux 2.2 tia mazek Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[SQL] rules on select - different output

Hi, I'd like my rule to change the row which is resulting form select. I'd like to get a row conforming to t1 from t2. CREATE TABLE t1 (id int, f1 int, f2 int, f3 text, f4 text); CREATE TABLE t2 (id int, p1 int, p2 text); CREATE RULE r1 AS ON SELECT TO t2 DO INSTEAD SELECT id, p1 AS f1, NULL::

[SQL] select with function per row

b=# select substr(substr(s.nazwa,strpos(s.nazwa,'a.')+2),1, textlen(s.nazwa)-strpos(s.nazwa,+'.m')) from serwery_old s; substr poznan mtl.pl ka.kie tia maz Marcin Mazurek -- Kierownik Działu Sy

Re: [SQL] grant select on ALL(?) to dbuser;

t way u have no > problems with privileges at all. i want to do it via cron, and rather not user any superusers, except for this it whould by nice to know how to do it not only for pg_dump:) maz Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[SQL] grant select on ALL(?) to dbuser;

Hi, is something like this possible? I have to grant select priviliges to dump database, and I was wondering if there is easer way to do it then name one, by one every table. maz Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/