Advertisement
Guest User

Untitled

a guest
Nov 20th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE FOREIGN TABLE "migration"."mssql_albarans_lines" (
  2.   "EmpCod" char(2) COLLATE "pg_catalog"."default" NOT NULL,
  3.   "AlcNri" int4 NOT NULL,
  4.   "AlcLin" int4 NOT NULL,
  5.   "AlmCod" int4,
  6.   "AlcCanPie" numeric,
  7.   "AlcFlgPU" char(1) COLLATE "pg_catalog"."default",
  8.   "AlcPre" numeric,
  9.   "AlcDsc" numeric,
  10.   "AlcIvaCod" int4,
  11.   "AlcIvaPor" numeric,
  12.   "AlcImpBas" numeric,
  13.   "AlcImpIva" numeric
  14. )
  15. SERVER "mssql_svr"
  16. OPTIONS ("row_estimate_method" 'showplan_all', "table" 'ALBCLL', "match_column_names" '0')
  17. ;
  18.  
  19. ALTER FOREIGN TABLE "migration"."mssql_albarans_lines"
  20.   OWNER TO "postgres";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement