How to Create a table in another database

From: Archana K N <archanakknn(at)gmail(dot)com>
To: PostgreSQLPHP PostgreSQLPHP <pgsql-php(at)postgresql(dot)org>
Subject: How to Create a table in another database
Date: 2015-11-12 10:26:52
Message-ID: CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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
--------------------

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Guillaume Lelarge 2015-11-12 18:56:45 Re: How to Create a table in another database
Previous Message Anthony Saubois 2015-07-23 13:44:35 Demande infos SQLCODE