File: f1db-data.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 (21 lines) | stat: -rw-r--r-- 540 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
load database
  from mysql://root@localhost/f1db
  into pgsql:///plop

  -- with data only, truncate
  
  WITH disable triggers, data only, no truncate,
       include no drop, create no tables, create indexes,
       reset sequences, no foreign keys,
       downcase identifiers, uniquify index names

  excluding table names matching ~/./

  materialize views circuit as
  $$
    select circuitid, circuitref, name, location, country,
           concat('(', lng, ',', lat, ')') as position,
           alt, url
     from circuits;
  $$;