Answer the question
In order to leave comments, you need to log in
Why can't I create a table with that name?
I want to create a table called id488796515 but it doesn't work.
And if you create a table called id488796516, then everything is fine. Why?
vk_conversations=# CREATE TABLE id488796515 (msg_id INTEGER NOT NULL,from_id INTEGER NOT NULL,attachments json[] NOT NULL,fwd_messages json[] NOT NULL);
^CCancel request sent
ОШИБКА: выполнение оператора отменено по запросу пользователя
КОНТЕКСТ: при добавлении кортежа индекса (9,44) в отношении "pg_type_typname_nsp_index"
vk_conversations=# CREATE TABLE id488796516 (msg_id INTEGER NOT NULL,from_id INTEGER NOT NULL,attachments json[] NOT NULL,fwd_messages json[] NOT NULL);
CREATE TABLE
vk_conversations=# \d
Список отношений
Схема | Имя | Тип | Владелец
--------+-------------+---------+----------
public | id488796516 | таблица | postgres
(1 строка)
vk_conversations=#
Answer the question
In order to leave comments, you need to log in
Sorry for the really stupid question. The mistake was made out of stupidity. (I forgot to close the connection in python)
First, a table is not a database. Secondly, judging by the message, you pressed Ctrl+C, so the table was not created.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question