Postgres Pro
Downloads
Home   >   mailing lists

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

From Archana K N
Subject How to Create a table in another database
Date
Msg-id CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com
Whole thread Raw
Responses Re: How to Create a table in another database  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: How to Create a table in another database  (Matthias Ritzkowski <matthiar@gmail.com>)
List pgsql-php
Tree view
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. 

--
-------------------
regards
Archana K N
--------------------

pgsql-php by date:

Previous
From: Anthony Saubois
Date:
Subject: Demande infos SQLCODE
Next
From: Guillaume Lelarge
Date:
Subject: Re: How to Create a table in another database