pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: itb348@gmail.com
To: pgsql-php@postgresql.org
Subject: Re: How to Create a table in another database
Date: Thu, 12 Nov 2015 21:21:47 +0100
Message-ID: <5644F4DB.9010702@googlemail.com> (raw)
In-Reply-To: <CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com>
References: <CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com>
	<CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-php>

On 12.11.2015 19:56, Guillaume Lelarge wrote:
> Hey,
>
> 2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn@gmail.com
> <mailto: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..." ?
>
>
to me it looks like Archana is mixing PHP and SQL.  "more details" certainly is the
right reaction here.

/Str.

view thread (7+ messages)  latest in thread

Message-ID: <5644F4DB.9010702@googlemail.com>
Permalink:  ../5644F4DB.9010702@googlemail.com/
Also on:    postgresql.org/message-id/5644F4DB.9010702@googlemail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: itb348@gmail.com
  Subject: Re: How to Create a table in another database
  In-Reply-To: <5644F4DB.9010702@googlemail.com>
  References: <CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com> <CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com> <5644F4DB.9010702@googlemail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox