I installed the postgresql-contrib package as it was available with my debian sarge 3.1 .
Then i just did
psql dbname < /usr/share/postgres/contrib/dblink.sql
I did some select operations using dblink and they worked perfectly.
When i tried to write a trigger in pl/pgsql like this ,
CREATE TRIGGER triggername BEFORE INSERT OR UPDATE ON testtable
FOR EACH ROW EXECUTE PROCEDURE test();...
krithikas
Last Activity: Mar 1 '07, 01:14 PM
Joined: Dec 28 '06
Location:
-
Thank you,
I found a function to_timestamp and it casts string into timestamp
I tried sth like ,
to_timestamp('0 1 Jan 2007 09:09:09', 'DD Mon YYYY HH:MI:SS')
It works .Leave a comment:
-
How to cast varchar into timestamp in postgres
I have a table (which i cannot modify) where date and time fields are stored as VARCHAR. But i have to cast these fields into timestamp.
My requirement is like,
timestamp (select date, time where max(timestamp(d ate,time));
How to do this in postgres? -
How to make cross-database reference in Postgres
Hello,
We have two postgres databases running in the same server. Now we have to write a trigger in one database to access a table in another database for live data updation in both databases. How can we perform that?
Can we use contrib/dblink? If we yes how to do that? Our postgres version is 7.4.7. And the function dblink does not exist.How to do that?
Or is there a better way of doing this cross reference.
...
No activity results to display
Leave a comment: