Postgres JSON import

Convert

Convert Json file to postgres statements

https://konbert.com/app/convert

Edit create table

Change datatype of taxId and add id column

CREATE TABLE IF NOT EXISTS "customer" (
"id" SERIAL PRIMARY KEY,
"givenName" TEXT NULL,
"familyName" TEXT NULL,
"birthName" TEXT NULL,
"gender" TEXT NULL,
"birthDate" TEXT NULL,
"height" INT NULL,
"eyecolor" TEXT NULL,
"email" TEXT NULL,
"taxId" TEXT NULL,
"address.addressCountry" TEXT NULL,
"address.addressLocality" TEXT NULL,
"address.postalCode" INT NULL,
"address.streetAddress" TEXT NULL,
"address.houseNumber" TEXT NULL,
"phoneNo" TEXT NULL,
"mobileNo" TEXT NULL,
"bankAccount.bank.city" TEXT NULL,
"bankAccount.bank.bankCode" INT NULL,
"bankAccount.bank.desc" TEXT NULL,
"bankAccount.bank.bic" TEXT NULL,
"bankAccount.iban" TEXT NULL,
"creditCard.number" TEXT NULL,
"creditCard.type" TEXT NULL,
"creditCard.cvc" INT NULL
);

Edit insert statement

added column names:

INSERT INTO customer ("givenName" ,
"familyName" ,
"birthName" ,
"gender" ,
"birthDate" ,
"height" ,
"eyecolor" ,
"email" ,
"taxId" ,
"address.addressCountry" ,
"address.addressLocality" ,
"address.postalCode" ,
"address.streetAddress" ,
"address.houseNumber" ,
"phoneNo" ,
"mobileNo" ,
"bankAccount.bank.city" ,
"bankAccount.bank.bankCode" ,
"bankAccount.bank.desc" ,
"bankAccount.bank.bic" ,
"bankAccount.iban" ,
"creditCard.number" ,
"creditCard.type" ,
"creditCard.cvc" ) VALUES