dblink can't query a password with a space

Поиск
Список
Период
Сортировка
От Hermann Muster
Тема dblink can't query a password with a space
Дата
Msg-id gh335n$158h$1@news.hub.org
обсуждение исходный текст
Список pgsql-general
I'm using the following dblink query to connect to another database on
the server. Query itself works fine, however I have the problem that if
the password contains a space character like in "hello world", then
dblink can't connect to that database.

Is there any possibility to get that working with dblink? I have to
dynamically create this view, so I have no choice if a user uses a
password like that. I suppose the same problem occurs when the user name
contains a space character.


CREATE VIEW MyView AS
SELECT * from dblink('host=TestHost port=5432 dbname=TestDB
user=postgres password=hello world','SELECT "Name" FROM "TestTable"') AS
(Name text);

Thank you,
H.Muster

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

Предыдущее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: Favorite Tom Lane quotes
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: Time without seconds