Re: installing dblink

On psql you may try \c <database name> [username]

On Fri, Jun 4, 2010 at 9:04 AM, Luiz Eduardo Cantanhede Neri <
lecneri(at)gmail(dot)com> wrote:

> On psql you may try \c <database name> [username]
>
>
> On Tue, May 18, 2010 at 10:43 PM, Oni <drentha(at)gmail(dot)com> wrote:
>
>> Tried to do a "use database" within postgres.
>>
>> Read the doco which said to use dblink. However this produced the
>> following error: "No function matches the given name and argument
>> types. You might need to add explicit type casts."
>>
>> So installed
>> apt-get install postgresql-contrib-8.3
>>
>> But it still didnt work. Read some more:
>> find /usr/share/postgresql -name dblink.sql (/usr/share/postgresql/
>> 8.3/contrib/dblink.sql)
>> cd /usr/share/postgresql/8.3/contrib
>> psql -d database -f dblink.sql
>>
>> psql database
>> SELECT * FROM dblink('dbname=database', 'select name, title from
>> pages') AS t1(name text, title text);
>>
>> And hey presto it works... and it only took 3 hours.
>>
>>
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>
>