Re: How to Create a table in another database

itb348@xxxxxxxxx · Thu, 12 Nov 2015 21:21:47 +0100



    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.