Re: character varying and varchar

From: Dave Page <dpage(at)postgresql(dot)org>
To: novnov <novnovice(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: character varying and varchar
Date: 2006-12-04 08:13:18
Message-ID: 4573D89E.3040305@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

novnov wrote:
> When 1.6 seems to have dropped varchar in favor of character varying.
> Shouldn't this be an option as opposed to an enforced behavior? I've read a
> little on the list about the change, but the problem is some packages I'm
> working with don't recognize character varying. Maybe that will change over
> time but in the meantime it's a change that does not help.
>
> It's kind of weird too - if I create a varchar field with pgAdmin III 1.4.2
> (windows), it's reported as varchar, including the ALTER TABLE statements
> for the col; but if I view the same table in pgAdmin 1.6, it's reported as
> character varying, even in the SQL?

They are *exactly* the same type on the server, we just use the SQL spec
compliant name now inline with psql and pg_dump etc.

I fail to see how your other packages can complain about the change
given that pgAdmin is only an administration front end, and what they
see on the server is no different than what is was when you used an
older version of pgAdmin.

Regards, Dave.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message kedar hukeri 2006-12-04 08:16:28 unsbuscrieb
Previous Message novnov 2006-12-04 04:04:43 character varying and varchar