On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <tg...@svwsjmc.org> wrote:
> I created a table in a hurry and forgot to specify the max capacity for a > varchar() data type. > Can it be said what the max would be in a case like this (just curious)? > > thanks much > > -- > Thomas A. Good, Senior Database Administrator > Saint Vincent's Hospital Westchester > A Division of Saint Joseph's Medical Center > Residential Services > 1216 Bay Street, Room L-8 > Staten Island, NY 10305 > 718.982.4752 > > "Wir leben, wir sind Glücksmaschinen." - Peter Hein > > This e-mail and any files transmitted with it are confidential and are > intended solely for the use of the individual or entity to who they are > addressed. This communication may contain protected health information > and/or material protected by the attorney-client privilege. If you are not > the intended recipient or the person responsible for delivering the e-mail > to the intended recipient, be advised that you have received this e-mail in > error and that any use, dissemination, forwarding, printing, or copying for > this e-mail is strictly prohibited. if you have received this e-mail in > error, please delete the message and attachments and notify the sender > immediately. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > According to http://www.postgresql.org/docs/current/static/datatype-character.html, "If character varying is used without length specifier, the type accepts strings of any size. The latter is a PostgreSQL extension." -Adam Cornett
