主页 / 问题 / 1183303
Accepted
Blacit
Asked:2020-09-28 04:56:17 +0800 CST2020-09-28 04:56:17 +0800 CST

错误：错误：关系“城市”已经存在

  • 772

我通过 pgAdmin4 创建了一个请求，它给出了一个错误“关系“城市”已经存在”。没有表格，所以也没有链接。

CREATE TABLE city
(
  id SERIAL PRIMARY KEY,
  id_region integer NOT NULL,
  name varchar(250) NOT NULL

);

INSERT INTO city (id, id_region, name) VALUES
(1, 1, 'Адыгейск'),
(2, 1, 'Майкоп'),
(3, 2, 'Горно-Алтайск'),
(4, 3, 'Алейск'),
(5, 3, 'Барнаул'),
(6, 3, 'Белокуриха'),
(7, 3, 'Бийск'),
(8, 3, 'Горняк'),
(9, 3, 'Заринск'),
(10, 3, 'Змеиногорск'),
(11, 3, 'Камень-на-Оби'),
(12, 3, 'Новоалтайск'),
(13, 3, 'Рубцовск'),
(14, 3, 'Славгород'),
(15, 3, 'Яровое'),
...
postgresql

1 个回答

  1. Best Answer

    养成使用图表的习惯

    CREATE TABLE {schemaname}.city
(
  id SERIAL PRIMARY KEY,
  id_region integer NOT NULL,
  name varchar(250) NOT NULL

);

INSERT INTO {schemaname}.city (id, id_region, name) VALUES
(1, 1, 'Адыгейск'),
(2, 1, 'Майкоп'),
(3, 2, 'Горно-Алтайск'),
(4, 3, 'Алейск'),
(5, 3, 'Барнаул'),
(6, 3, 'Белокуриха'),
(7, 3, 'Бийск'),
(8, 3, 'Горняк'),
(9, 3, 'Заринск'),
(10, 3, 'Змеиногорск'),
(11, 3, 'Камень-на-Оби'),
(12, 3, 'Новоалтайск'),
(13, 3, 'Рубцовск'),
(14, 3, 'Славгород'),
(15, 3, 'Яровое');

    也不会有这样的问题

    • 0

相关问题