[GENERAL] Foreign Key relationship between two databases

2005-01-27 Thread Sandeep Gaikwad
Hi, I am using postgres 7.3.4. I am new to postgres. I can give foreign key relationship between two tables of same database. Can I give foreign key relationship between tables of two databases ? Plz, let me know if possible & send me how can I do that? Thanks & Regards, Sandeep. --

[GENERAL] URL activation through trigger

2005-01-27 Thread Sandeep Gaikwad
Hi, I am using Postgres 7.3.4. I want to write a trigger for insert, update, delete operation on say, user table. This trigger will activate an URL. URL will be as: http://sandeep/Trigger?userid=4&name=sandeep where, userid and password will be parameters to send. They may taken from

Re: [GENERAL] Problem performing a restore of a data schema in Windows

2005-02-07 Thread Sandeep Gaikwad
Hi, Can u please try with the following command: pg_dump -s dbname >DumpFileName.dmp or pg_dump -s -u dbname >DumpFileName.dmp For the second, you will be asked for username & password. Regards, Sandeep Shaun Clements wrote: Hi All Im having a problem restoring a data schema on Postgres 8.01 fo