Postgres Pro
Downloads
Home   >   mailing lists

Display Length Between Var & Varchar - Mailing list pgsql-sql

From Carlos Mennens
Subject Display Length Between Var & Varchar
Date
Msg-id CAAQLLO6wQ0b--_Y1LVR5S68HW6Wi7msOAmvELhaLE7cNmOtFCw@mail.gmail.com
Whole thread Raw
Responses Re: Display Length Between Var & Varchar  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: chester c young
Date:
Subject: Fw: Re: pg_dump not correctly saving schema with partitioned tables?
Next
From: Adrian Klaver
Date:
Subject: Re: Display Length Between Var & Varchar