ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> 其他数据库 >> Redshift 通过重新建表修改varchar60 到varchar90

Redshift 通过重新建表修改varchar60 到varchar90(3/13)

来源:网络整理     时间:2017-10-13     关键词:

本篇文章主要介绍了" Redshift 通过重新建表修改varchar60 到varchar90",主要涉及到方面的内容,对于其他数据库感兴趣的同学可以参考一下: 首先需要知道的是redshift不支持SQL语法直接修改varchar(60) 到varchar(90),但PostgreSQL和MySQL都支持。1.Post...

    entity_id character varying(300),

    utc_timestamp timestamp without time zone,

    time_zone character varying(60),

    ad_id character varying(60),

    os_version character varying(20),

    connection_type character varying(10),

    device_make character varying(20),

    device_model character varying(50),

    gps_state character varying(10),

    map_source character varying(10),

    current_lat numeric(15,6),

    current_lon numeric(15,6),

    altitude numeric(15,6),

    horizontal_accuracy numeric(15,6),

    vertical_accuracy numeric(15,6),

    nav_timestamp timestamp without time zone,

    speed numeric(15,6),

    assumed_speed numeric(15,6),

    traffic_speed numeric(15,6),

    heading character varying(50),

    edge_id character varying(20),

    trigger character varying(30),

    type character varying(50),

    display_screen character varying(50),

    vendor character varying(20),

    incident_vendor character varying(20),

相关图片

相关文章