pg2mysql icon indicating copy to clipboard operation
pg2mysql copied to clipboard

interval type fields not supported

Open johanek opened this issue 11 months ago • 0 comments

I'm not sure what these should be converted to, but internal isn't a valid type in mysql

$ cat test.pgsql
CREATE TABLE public.dcim_device (
    id uuid NOT NULL,
    created date,
    diff_time interval,
);

$ perl pg2mysql.pl < test.pgsql
--
-- Generated by pg2mysql
--
set foreign_key_checks = off;
--
DROP DATABASE IF EXISTS public;
CREATE DATABASE public;
CREATE TABLE public.dcim_device (
    `id` varchar(36) NOT NULL,
    `created` date,
    `diff_time` interval,
);

johanek avatar Aug 30 '23 10:08 johanek