Re: moving char() to varchar()

From: "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: moving char() to varchar()
Date: 2001-09-07 19:54:58
Message-ID: 20010907195458.57906.qmail@web13005.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Andrew Sullivan <andrew(at)libertyrms(dot)com> wrote:
> 1. I thought the SQL spec required varchar() not to pad. Is
> it
> just that, because of the way pg_dump saved the char() data
> (as
> blank-padded) that the varchar() field preserves the padded
> data?

The pg_dump utility dumps out the data as is so all CHAR columns
would be dumped with the accompanying padding spaces.

Brent

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-07 20:01:46 Re: What Is The Firing Order?
Previous Message Mitch Vincent 2001-09-07 19:50:33 Re: moving char() to varchar()