I have just set up my first Postgresql database and I was wondering if
it is more efficient to use the Text data type or the Varchar(n) data
type.

Thanks for your help,


kevin crenshaw

On Tue, Feb 08, 2005 at 11:09:09PM -0500, Kevin Crenshaw wrote:
>
> I have just set up my first Postgresql database and I was wondering if
> it is more efficient to use the Text data type or the Varchar(n) data
> type.

The FAQ and documentation discuss the similarities and differences
between the character types:

http://www.postgresql.org/files/docu.../FAQ.html#4.10
http://www.postgresql.org/docs/8.0/s...character.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)