Re: Add "varchar" to the list in field defs... - Mailing list pgadmin-support

From durumdara
Subject Re: Add "varchar" to the list in field defs...
Date
Msg-id 4A4DF3A4.2090705@gmail.com
Whole thread Raw
In response to Re: Add "varchar" to the list in field defs...  (Marcin Stępnicki <mstepnicki@gmail.com>)
Responses Graphical sql query builder
List pgadmin-support
Hi!<br /><br /> 2009.07.03. 12:52 keltezéssel, Marcin Stępnicki írta: <blockquote
cite="mid:179149fe0907030352td5c85fdwcb4ca8f25600df9d@mail.gmail.com"type="cite"><pre wrap="">2009/7/3 durumdara <a
class="moz-txt-link-rfc2396E"href="mailto:durumdara@gmail.com"><durumdara@gmail.com></a>: </pre><blockquote
type="cite"><prewrap="">Hi!
 

In the field definitions I cannot type varchar, because the other properties
are disabled.
I must type cha*, and if autocompleted, I need to hit tab + space + "v"...

It would be easier if I can use "varchar", and "varchar" is automatically
changed to "character variable"...   </pre></blockquote><pre wrap="">
Good point, but let me take notice that you should probably use "text"
type anyway ;-). If you don't have a very good reason for specifying a
limit, simply don't bother. There is no speed penalty in accessing
"text" fields - in fact you can even gain a few miliseconds on
insert/update, because the limit check is omitted.The same applies to
"char".

And personally I think that "text" looks nicer than "character varying" :-).

<a class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/8.3/interactive/datatype-character.html">http://www.postgresql.org/docs/8.3/interactive/datatype-character.html</a>

Regards,
Marcin </pre></blockquote> Sometimes your idea is good, but sometimes is not.<br /><br /> Normally some applications we
usedare limited field lengths in DB. Ok, native apps like wrote in Delphi limits the fields in DataSets, but in web I
mustcheck all input fields.<br /> The truncation is good if I miss the checks...<br /><br /> Varchar sizes needed also
iftwo of databases (f. e: PGSQL and DBISAM) exchange some datas... In DBISAM the varchar is char that limited to 250
char.<br/><br /> So I use your "text" but not all times.<br /><br /> Thanks for your help:<br />     dd<br /><br /><br
/>

pgadmin-support by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Re: Add "varchar" to the list in field defs...
Next
From: durumdara
Date:
Subject: [Suggestions] IDE enhancements...