E
E
Evgeny Petryaev2021-04-25 20:44:36
PostgreSQL
Evgeny Petryaev, 2021-04-25 20:44:36

Why strange spaces in the console?

Created this table:

Create table table_workers(id serial primary key,name character(256) unique,position character(64)); 
CREATE TABLE table_tasks(id serial primary key,task character(1024),parent_task integer,executor character(256),date_death_line date,date_start date,status character(64),foreign key (parent_task) references table_tasks(id),foreign key (executor) references table_workers(name));
Insert into table_workers values(1,'Ivanov Ivan Ivanovich','Developer');
Insert into table_tasks values(1,'Добавить личный кабинет на сайт',NULL,'Ivanov Ivan Ivanovich','2020-05-01','2020-04-19','Назначено');

The exhaust is like this:
6085aa0802bf4284796294.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Daria Motorina, 2021-04-25
@Gremlin92

In the character data type, the empty part of the field is filled with spaces, and they spoil the console data output
https://www.postgresql.org/docs/9.1/datatype-chara...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question