Myvideo

Guest

Login

Postgres dblink - conexin a otra base de datos

Uploaded By: Myvideo
1 view
0
0 votes
0

Como conectarse a otra base de datos incluso de otro servidor usando el módulo DBLINK que viene con nuestro manejador de base de datos PostgreSQL. Sisplani eirl ventas@ 51 997017670 -- /share/contrib/ o create extension dblink CREATE TABLE doctipo ( doctipo_descri character varying(50) DEFAULT ''::character varying, -- descripción del tipo de documento doctipo_id character varying(5) NOT NULL DEFAULT ''::character varying, -- ID del tipo de documento CONSTRAINT pk_doctipo PRIMARY KEY (doctipo_id) ) WITH ( OIDS=FALSE ); CREATE OR REPLACE FUNCTION dblink_test() RETURNS void AS $BODY$ /* Autor: Guillermo Arias ejemplo: select (); cargar: /share/contrib/ o */ declare cRpta varchar; begin cRpta := (select dblink_connect('myconn','hostaddr= port=5432 dbname

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later