Display Length Between Var & Varchar
От | Carlos Mennens |
---|---|
Тема | Display Length Between Var & Varchar |
Дата | |
Msg-id | CAAQLLO6wQ0b--_Y1LVR5S68HW6Wi7msOAmvELhaLE7cNmOtFCw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Display Length Between Var & Varchar
|
Список | pgsql-sql |
I've noticed when I set a field to char, it takes up lots of space over varchar: iamunix=# SELECT * FROM music;id | band | album | date | asin | label ----+-------------------+--------------------------+------------+----------------------------------------------------+-------------- 1| Dance Gavin Dance | Downtown Battle Mountain | 2007-05-15 | B000OQF4PQ | Rise Records (1 row) iamunix=# SELECT * FROM music;id | band | album | date | asin | label ----+-------------------+--------------------------+------------+------------+-------------- 1 | Dance Gavin Dance | DowntownBattle Mountain | 2007-05-15 | B000OQF4PQ | Rise Records (1 row) I don't know how well it will show in plain text via email but does anyone know why the field display width is wasted with so much white space when set to char?
В списке pgsql-sql по дате отправления: