| 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:34:04 | 
| Message-ID: | 7B8D269D66BB354E9EE6BD61D384556C018BD36F@de020204.emea.luk.com | 
| Views: | Whole Thread | Raw Message | 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 but maybe there is a better way in doing
such a thing???
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 | Wright, George | 2008-07-11 12:50:08 | Re: function source | 
| Previous Message | Schoenit, Tobias AT/BHL-ZTPS | 2008-07-11 11:28:24 | Dataimport from remote db |