| From: | Derik Barclay <dbarclay(at)givex(dot)com> |
|---|---|
| To: | "Stewart, Robert D (COT)" <RobertD(dot)Stewart(at)ky(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about varchar and text |
| Date: | 2005-01-06 18:05:24 |
| Message-ID: | 200501061305.24234.dbarclay@givex.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I don't know about running faster, but I believe the only difference between
the two in postgres is that a varchar has a limit on input. They are stored
and indexed the same.
On January 6, 2005 12:25 pm, Stewart, Robert D (COT) wrote:
> What is the difference between varchar and text?
> I have heard that you can use text instead of varchar and this could speed
> up your tables.
>
>
> Robert Stewart
> Network Eng
> Governor's Office of Technology
> 101 Cold Harbor
> Work # 502 564 9696
> Cell # 502 330 5991
> Email RobertD(dot)Stewart(at)ky(dot)gov
--
Givex - http://www.givex.com/
Derik Barclay <dbarclay(at)givex(dot)com>, Systems Software Engineer
+1 416 350 9660
+1 416 250 9661 (fax)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Brown | 2005-01-06 18:08:45 | Editor: Syntax highlighting and stored procedures surrounded by ' |
| Previous Message | Michael Fuhr | 2005-01-06 18:04:18 | Re: pg_dump dependencies |