Dataim****t from remote db

Hello,

i have several machines having the same database layout. Now i want
im****t data from a remote machine.=20

I tried something like this but maybe there is a better way in doing
such a thing???

CREATE OR REPLACE FUNCTION im****t_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 :=3D 'hostaddr=3D' || v_host || ' dbname=3Dconfig
user=3Duser password=3Dpass';

		-- 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))=20
		LOOP
			INSERT INTO config (id, name) values
(v_config.id, v_config.name);
		END LOOP;

		PERFORM 'SELECT dblink_disconnect (''con'');';
=09=09
		v_return :=3D 4;
		RETURN v_return;

	END;
$$ LANGUAGE 'plpgsql';


But now I get:
NOTICE:  connected

ERROR:  could not establish connection
DETAIL:  missing "=3D" after "'con'" in connection info string

CONTEXT:  PL/pgSQL function "im****t_sc" line 13 at FOR over SELECT rows

********** Fehler **********

ERROR: could not establish connection
SQL Status:08001
Detail:missing "=3D" after "'con'" in connection info string
Kontext:PL/pgSQL function "im****t_sc" line 13 at FOR over SELECT rows


What does that mean?

Thank you very much.
Tobias

--=20
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice