{"id":1523,"date":"2017-07-25T17:28:02","date_gmt":"2017-07-25T17:28:02","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1523"},"modified":"2017-07-25T17:40:29","modified_gmt":"2017-07-25T17:40:29","slug":"copiar-campos-de-una-tabla-a-otra-en-diferentes-bd-en-postgresql","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/copiar-campos-de-una-tabla-a-otra-en-diferentes-bd-en-postgresql\/","title":{"rendered":"Copiar campos de una tabla a otra en diferentes bd en PostgreSQL"},"content":{"rendered":"<p>Siendo el sgte. caso: Tenemos 2 base de datos con muni1 y muni2. La base de datos muni1 tiene la tabla\u00a0\u00a0 contribuyente con los sgtes. campos con_id, con_razonsocial, con_nrodoc, con_eliminado, con_direccion, con_email, tipc_id, tipd_id\u00a0 y la bd muni2 tiene tambi\u00e9n la tabla contribuyente con los campos con_id, con_razonsocial, con_nrodoc, con_eliminado, con_email, tipc_id, tipd_id. Entonces queremos copiar todos los datos de la tabla muni1.contribuyente a muni2.contribuyente sin la columna con_direccion. Para eso usamos las sgtes. sentencias.<\/p>\n<p>En la bd muni1 copiamos solo los campos que queremos en un archivo .tvs delimitado por tabuladores.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">COPY contribuyente( con_id, con_razonsocial, con_nrodoc, con_eliminado, con_email, tipc_id, tipd_id  )  TO 'D:\\contribuyente.tvs'  WITH  DELIMITER E'\\t';<\/pre>\n<p>Ahora en muni2 restauramos el archivo generado indicando tambi\u00e9n los campos<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">COPY contribuyente( con_id, con_razonsocial, con_nrodoc, con_eliminado, con_email, tipc_id, tipd_id  )  FROM 'D:\\contribuyente.tvs'  WITH  DELIMITER E'\\t';<\/pre>\n<p>Un poco mas. Yo ahora necesito pasar otros campos mas de la tabla contribuyente de muni1 a una tabla predio de muni2. Entonces seria:<\/p>\n<p>En muni1<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">COPY contribuyente( con_id, con_direccion, sec_id, uso_id  ) TO 'D:\\predio.tvs'  WITH  DELIMITER E'\\t';<\/pre>\n<p>En muni2<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">COPY predio( con_id, pre_direccion, sec_id, uso_id  ) FROM 'D:\\predio.tvs'  WITH  DELIMITER E'\\t';<\/pre>\n<p>En mi caso ya tengo una tabla contribuyente relacionado con una tabla predio debidamente llenada con sus relaciones.<\/p>\n<p>servidos!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Siendo el sgte. caso: Tenemos 2 base de datos con muni1 y muni2. La base de datos muni1 tiene la tabla\u00a0\u00a0 contribuyente con los sgtes. campos con_id, con_razonsocial, con_nrodoc, con_eliminado, &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[29,30],"class_list":["post-1523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","tag-copy-table-postgresql","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/comments?post=1523"}],"version-history":[{"count":3,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1523\/revisions"}],"predecessor-version":[{"id":1527,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1523\/revisions\/1527"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1524"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}