Postgres Pro
Downloads
Home   >   mailing lists

Re: moving char() to varchar() - Mailing list pgsql-general

From Brent R. Matzelle
Subject Re: moving char() to varchar()
Date
Msg-id 20010907195458.57906.qmail@web13005.mail.yahoo.com
Whole thread Raw
In response to moving char() to varchar()  (Andrew Sullivan <andrew@libertyrms.com>)
List pgsql-general
Tree view 
--- Andrew Sullivan <andrew@libertyrms.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

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: moving char() to varchar()
Next
From: Bruce Momjian
Date:
Subject: Re: What Is The Firing Order?