test_pg.sql 364 B

123456789101112
  1. DROP TABLE IF EXISTS test;
  2. CREATE TABLE "test" (
  3. "id" serial,
  4. "name" varchar(255) NOT NULL,
  5. "population" integer,
  6. PRIMARY KEY ("id")
  7. );
  8. INSERT INTO "test" ("name", "population") VALUES ('Київ', 2804000);
  9. INSERT INTO "test" ("name", "population") VALUES ('Львів', 723605);
  10. INSERT INTO "test" ("name", "population") VALUES ('Одеса', 997189);