mirror of
https://github.com/Monadical-SAS/reflector.git
synced 2025-12-20 20:29:06 +00:00
17 lines
417 B
Fish
17 lines
417 B
Fish
LOAD DATABASE
|
|
FROM sqlite:///app/reflector.sqlite3
|
|
INTO pgsql://reflector:reflector@postgres:5432/reflector
|
|
WITH
|
|
include drop,
|
|
create tables,
|
|
create indexes,
|
|
reset sequences,
|
|
preserve index names,
|
|
prefetch rows = 10
|
|
SET
|
|
work_mem to '512MB',
|
|
maintenance_work_mem to '1024MB'
|
|
CAST
|
|
column transcript.duration to float using (lambda (val) (when val (format nil "~f" val)))
|
|
;
|