From: | "Schoenit, Tobias AT/BHL-ZTPS" <tobias(dot)schoenit(at)schaeffler(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Dataimport from remote db |
Date: | 2008-07-11 11:28:24 |
Message-ID: | 7B8D269D66BB354E9EE6BD61D384556C018BD360@de020204.emea.luk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
i have several machines having the same database layout. Now i want
import data from a remote machine.
I tried something like this:
CREATE OR REPLACE FUNCTION import_sc(text)
RETURNS int4 AS $$
DECLARE
v_host ALIAS FOR $1;
v_return int4;
v_constr text;
v_config record;
temp record;
BEGIN
v_constr := 'hostaddr=' || v_host || ' dbname=config
user=user password=pass';
-- connect to remote database
PERFORM 'SELECT dblink_connect(''con'', v_constr);';
RAISE NOTICE 'connected';
FOR v_config in (SELECT * from dblink('''con''',
'SELECT * from config ') AS
hc(id character(36), name text))
LOOP
INSERT INTO config (id, name) values
(v_config.id, v_config.name);
END LOOP;
PERFORM 'SELECT dblink_disconnect (''con'');';
v_return := 4;
RETURN v_return;
END;
$$ LANGUAGE 'plpgsql';
But now I get:
NOTICE: connected
ERROR: could not establish connection
DETAIL: missing "=" after "'con'" in connection info string
CONTEXT: PL/pgSQL function "import_sc" line 13 at FOR over SELECT rows
********** Fehler **********
ERROR: could not establish connection
SQL Status:08001
Detail:missing "=" after "'con'" in connection info string
Kontext:PL/pgSQL function "import_sc" line 13 at FOR over SELECT rows
What does that mean?
Thank you very much.
Tobias
From | Date | Subject | |
---|---|---|---|
Next Message | Schoenit, Tobias AT/BHL-ZTPS | 2008-07-11 11:34:04 | Dataimport from remote db |
Previous Message | Ridvan Lakas ng Bayan S. Baluyos | 2008-07-11 07:27:24 | Number of postgres connections |