/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/sqlite.load
19 строк
575 B
Dimitri Fontaine
Implement a new “snake_case” quoting rule.
13 сен 2017, 23:55
13 сен 2017, 23:55
dbadab9
Код
Авторство
О чём код?
load database from 'sqlite/sqlite.db' into postgresql:///pgloader -- with include drop, create tables, create indexes, reset sequences with snake_case identifiers 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';