X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 320AB11F6D2A for ; Thu, 20 Apr 2006 00:32:08 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 3.559 X-Spam-Level: *** X-Spam-Status: No, score=3.559 required=5 tests=[BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_WHOIS=1.447, FROM_HAS_MIXED_NUMS=2.155, HTML_40_50=0.496, HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id YJIaZqMvTORu for ; Thu, 20 Apr 2006 00:32:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web33408.mail.mud.yahoo.com (web33408.mail.mud.yahoo.com [68.142.206.140]) by postgresql.org (Postfix) with SMTP id 474CF11F6D22 for ; Thu, 20 Apr 2006 00:32:04 -0300 (ADT) Received: (qmail 50063 invoked by uid 60001); 20 Apr 2006 03:32:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=s2O8n6aJK32tOq7gTRQVKWGjMnSB0lNaSIXWPbQo+LJZdr45K7DCfR0YbgNH/CiyVauAGNmzhUknMSIsCHuHn3uOE44O4RRmPd4ToGQ0cCkJNbiICEGrNzCUSrS8OCwrM9MRDhQ8vFCp0gPi/RvelPUJEu7ZHFgPGG5JQ1jPXUs= ; Message-ID: <20060420033202.50061.qmail@web33408.mail.mud.yahoo.com> Received: from [222.124.227.199] by web33408.mail.mud.yahoo.com via HTTP; Wed, 19 Apr 2006 20:32:02 PDT Date: Wed, 19 Apr 2006 20:32:02 -0700 (PDT) From: Louise Catherine Subject: Field length ?? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1025070810-1145503922=:48676" Content-Transfer-Encoding: 8bit X-Archive-Number: 200604/130 X-Sequence-Number: 24939 --0-1025070810-1145503922=:48676 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I've this table : create table test(] satu char(10), dua char(5) ); How could I get the Field length not the Data length ? Thanks, Rina --------------------------------- Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. --0-1025070810-1145503922=:48676 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I've this table :

create table test(]
satu char(10),
dua char(5)
);

How could I get the Field length not the Data length ?


Thanks,
Rina


Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. --0-1025070810-1145503922=:48676--