Re: [GENERAL] dblink & 4 master operation

2009-09-12 Thread Mohsen Pahlevanzadeh
Dear all, I use following command : su - su postgres cd ~ psql urldump urldump=# \i /usr/share/postgresql/8.4/contrib/dblink.sql . urldump=# select dblink_connect('my','dbname=urldump'); dblink_connect OK (1 row) urldump=# select dblink('my','INSERT INTO ipmap (ip,username

[GENERAL] dblink & 4 master operation

2009-09-12 Thread Mohsen Pahlevanzadeh
Dear all, My boss requested me that i use dblink even for a sample INSERT, now i have a INSERT query, But i don't know how to invoke insert query without select query. I have search for doc in this topic, But i just saw API ref in postgresql.org. Can u help me? Yours, Mohsen -- Sent via pgsql-