How to alter table to have uuid?

Answers

• marcothesane Administrator

  July 2021

  If your table is:

  CREATE TABLE migrate_me (
    id        UUID NOT NULL DEFAULT UUID_GENERATE()
  , fname VARCHAR(32)
  , lname  VARCHAR(32)
  );
  

  Then, if you use CSV files for the migration, export all columns to CSV, create the same table on the other side and perform a normal COPY migrate_me FROM '/data/migrate_me.csv' DELIMITER ',' /* or whatever applies */[...];.

  If you had no UUID at the source (I did not figure that out exactly from your question), like so:

  CREATE TABLE migrate_me (
    fname VARCHAR(32)
  , lname  VARCHAR(32)
  );
  

  , then also export all columns you have, create the table like so on the other side:

  CREATE TABLE migrate_me (
    id        UUID NOT NULL DEFAULT UUID_GENERATE()
  , fname VARCHAR(32)
  , lname  VARCHAR(32)
  );
  

  , and copy the CSV file like so:

  COPY migrate_me (
    fname
  , lname
  )
  FROM '/data/migrate_me.csv' DELIMITER ','
  [...]
  ;
  

  0
• iddpanganiban

  July 2021

  thanks for the response sir @marcothesane

  0