mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
b8e8cf7d18
Materialized views without an explicit schema name are supported, but then would raise an error when trying to use destructuring-bind on a string rather than the (cons schema-name table-name). This patch fixes that.
15 lines
457 B
Fish
15 lines
457 B
Fish
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');
|
|
$$
|
|
;
|