CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> Just something I was curious about - is there any
> difference at all between "character varying" (in the
> SQL spec) without a length specified and "text" (not
> in the SQL spec)?
The SQL standard doesn't allow "character varying" without a length spec.
But yeah, in Postgres they're essentially the same thing.
regards, tom lane