|
On 11/16/2015 2:31 AM, Sachin
Srivastava wrote:
that is part of the 'contributed extension' dblink. the way you install the contrib modules depends on your flavor of linux, AND how you installed postgresql in the first place, for instance, on a RHEL system where PG was installed from the yum.postgresql.org repository, # yum install postgresql94-contrib on a debian/ubuntu flavored postgres, it would be something involving apt-get once the contrib modules exist on the system, as a postgres superuser, to intsall a specific contrib module, you need... $ psql yourdb .... yourdb=# create extension dblink; and from now on, the dblink functions are available in that database. -- john r pierce, recycling bits in santa cruz |
