File: pgsql-source.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 (14 lines) | stat: -rw-r--r-- 457 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
load database
     from pgsql://localhost/pgloader
     into pgsql://localhost/copy

  -- including only table names matching 'bits', ~/utilisateur/ in schema 'mysql'
  including only table names matching ~/geolocations/ in schema 'public'

  materialize views some_usps
  as $$
    select usps, geoid, aland, awater, aland_sqmi, awater_sqmi, location
      from districts
     where usps in ('MT', 'DE', 'AK', 'WY', 'PR', 'VT', 'SD', 'DC', 'ND');
  $$
  ;