Dataimport from remote db

Поиск
Список
Период
Сортировка
От Schoenit, Tobias AT/BHL-ZTPS
Тема Dataimport from remote db
Дата
Msg-id 7B8D269D66BB354E9EE6BD61D384556C018BD360@de020204.emea.luk.com
обсуждение исходный текст
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Ridvan Lakas ng Bayan S. Baluyos"
Дата:
Сообщение: Number of postgres connections
Следующее
От: "Schoenit, Tobias AT/BHL-ZTPS"
Дата:
Сообщение: Dataimport from remote db