File: ixf.load

package info (click to toggle)
pgloader 3.6.10-5
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 12,060 kB
  • sloc: sql: 32,321; lisp: 14,793; makefile: 435; sh: 85; python: 26
file content (11 lines) | stat: -rw-r--r-- 311 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
 
LOAD IXF
    FROM data/nsitra.test1.ixf
    INTO postgresql:///pgloader
    TARGET TABLE nsitra.test1
    
    WITH on error stop, truncate, create table, timezone UTC

  BEFORE LOAD DO
   $$ drop schema if exists nsitra cascade; $$,
   $$ create schema nsitra; $$,
   $$ drop table if exists nsitra.test1; $$;