/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/sqlite-env.load
26 строк
742 B
Dimitri Fontaine
Implement a template system for pgloader commands.
16 авг 2017, 02:33
16 авг 2017, 02:33
f719d29
Код
Авторство
О чём код?
/* * Run with either one of those commands: * * DBPATH=sqlite/sqlite.db ./build/bin/pgloader ./test/sqlite-env.load * ./build/bin/pgloader --context ./test/sqlite.ini ./test/sqlite-ini.load * */ load database from '{{DBPATH}}' into postgresql:///pgloader -- with include drop, create tables, create indexes, reset sequences before load do $$ drop schema if exists sqlite cascade; $$, $$ create schema if not exists sqlite; $$ cast column character.f1 to text drop typemod, column appointments.time to timestamptz drop default, type intege to integer, type character to varchar keep typemod set work_mem to '16MB', maintenance_work_mem to '512 MB', search_path to 'sqlite';