Do it like this:
create table a (b varchar);
In this usage, varchar is pretty much an alias for text, but some database
front ends find it easier to accept type varchar than text.
On Tue, 10 Sep 2002, Tourtounis Sotiris wrote:
> I have listened that through new Postgresql 7.2.2 version there is also
> the capability of declaring a varchar type without declaring the maximum
> number of storage e.g. create table A(att0 varchar(16)). Is is true?If
> it's how is declared beacuse i can't manage it. Specifically i can't
> declare create table A(att0 varchar()). Does anyone have any idea about
> the subject.Thanks you !
>
>
>
> SWTHRHS TOYRTOYNHS
> (tourtoun@csd.uch.gr)
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
