Re: How to Create a table in another database
| От | Matthias Ritzkowski |
|---|---|
| Тема | Re: How to Create a table in another database |
| Дата | |
| Msg-id | CAEqybvkQVrK2p-_LWiwVKRoncRvPK70ibceCSfZv9juFNRo8LA@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to Create a table in another database (Archana K N <archanakknn@gmail.com>) |
| Список | pgsql-php |
Have you installed AND activated dblink?
You can check with \dx from a pgsql prompt ...
This is a good guide:
http://michael.otacoo.com/postgresql-2/first-steps-with-dblink-on-postgres/
regards
Matthias Ritzkowski
On Nov 12, 2015 05:27, "Archana K N" <archanakknn@gmail.com> wrote:
Hello,I created a postgres function in db1, from which I need to create a table in another database say db2. I tried to use 'dblink' but it is giving the error:-ERROR: function dblink_connect(unknown, unknown) does not existLINE 1: select dblink_connect('dbname=mydb port=5432 host=localhost ...^HINT: No function matches the given name and argument types. You might need to add explicit type casts.Have been stuck on this for 2 days. Dont know what to do.I am using Windows 7 OS(32-bit) and due to certain security purpose am using Postgres 9.0(cant update it to newer version).Please help me.---------------------
regards
Archana K N
--------------------
В списке pgsql-php по дате отправления: