[9.2] installation of DBLINK and using DBLINK Query

/************************************************************************************************
-- Title : [9.2] installation of DBLINK and using DBLINK Query
-- Reference : postgresql.org
-- Key word : postgresql dblink linked_server linked server 디비링크 디비 링크
************************************************************************************************/

-- confirm db_link file installed in advance

-- is there dblink--1.0.sql or dblink--unpackaged--1.0.sql?

    $ ls /home/postgres/pgsql/share/extension

       -rw-r--r--. 1 root     root     5569 2013-09-15 17:53 dblink--1.0.sql

       -rw-r--r--. 1 root     root     2847 2013-09-15 17:53 dblink--unpackaged--1.0.sql

       -rw-r--r--. 1 root     root      170 2013-09-15 17:53 dblink.control

-- make install(if there is not dblink--1.0.sql or dblink--unpackaged--1.0.sql..)

    $ exit

    # cd /usr/local/src/postgresql-9.2.4/contrib/dblink

    # make install

    

-- confirm dblink* files

    $ su - postgres

    $ cd /home/postgres/pgsql/share/extension

    $ ls dblink*

      dblink--1.0.sql  dblink--unpackaged--1.0.sql  dblink.control

-- creation extention

    =# create extension dblink;

       쿼리는 291 로 결과값 없이 잘 실행되었습니다.

-- confirm added dblink extention on psql

    =# \dx

    

-- confirm added dblink extention on pgAdmin III

-- execution dblink query

select *

from dblink('dbname=tttdb',

            'select customer_id, store_id, first_name 

             from sch_customer.customer

            '

           )as t1(a int, b smallint, c varchar(45));