Re: How to Create a table in another database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On 12.11.2015 19:56, Guillaume Lelarge wrote:
Hey,

2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn@xxxxxxxxx>:
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..." ?


to me it looks like Archana is mixing PHP and SQL.  "more details" certainly is the right reaction here.

/Str.

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux