Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Create a table in another database - Mailing list pgsql-php

From Guillaume Lelarge
Subject Re: How to Create a table in another database
Date
Msg-id CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com
Whole thread Raw
In response to How to Create a table in another database  (Archana K N <archanakknn@gmail.com>)
Responses Re: How to Create a table in another database  (itb348@gmail.com)
List pgsql-php
Tree view
Hey,

2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn@gmail.com>:
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 exist
   LINE 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. 


Have you installed dblink on the db1 database? If yes, can you give us the complete query that begins with "select dblink_connect..." ?

Thanks.


--

pgsql-php by date:

Previous
From: Archana K N
Date:
Subject: How to Create a table in another database
Next
From: itb348@gmail.com
Date:
Subject: Re: How to Create a table in another database