Postgres Snippets

Postgres

DROP TABLE "public"."varCalcValue";
CREATE TABLE "public"."varCalcValue" (
  "id" bigint NOT NULL GENERATED ALWAYS AS IDENTITY,
  "varCalcValue" VARCHAR(50) NOT NULL,
  "createdOn" TIMESTAMP NULL,
  "updatedOn" TIMESTAMP NULL
);

CREATE TABLE new_table_name AS
SELECT * FROM "uniRoomTypeValueCode""
WHERE conditions;

INSERT INTO "uniRoomTypeFeature"
SELECT "uniRoomTypeFeatureName", "uniRoomTypeFeature"
FROM "RoomTypeFeatures"


INSERT INTO "uniRoomTypeFeature"("uniRoomTypeFeatureName", "uniRoomTypeFeature")
SELECT
    "uniRoomTypeFeatureName",
    "uniRoomTypeFeature"
FROM
    "public"."RoomTypeFeatures"
   
   




  CONSTRAINT "varCalcValue_pkey" PRIMARY KEY ("id")
  
  ALTER TABLE
  "public"."varCalcValue"
ADD
  CONSTRAINT property_pkey PRIMARY KEY (id)
  
  
  CREATE TABLE "public"."varCalcType" ( 
  "id" bigint NOT NULL GENERATED ALWAYS AS IDENTITY,
  "varCalcType" VARCHAR(50) NOT NULL,
  "varCalcTypeDescription" VARCHAR(250) NULL,
  "createdOn" TIMESTAMP NULL,
  "updatedOn" TIMESTAMP NULL,
   CONSTRAINT "varCalcType_pkey" PRIMARY KEY ("id")
);