I'm not sure where to find it exactly, but does anyone know how much
data a column of type "text" in a postgres DB can hold?
Thanks 3 7737
On Wed, 2004-10-13 at 14:58, John Ossmann wrote: I'm not sure where to find it exactly, but does anyone know how much data a column of type "text" in a postgres DB can hold?
There is no limit on what "text" itself can contain. However, a field of
any data type can contain at most 1GB (compressed -- Postgres will do
this compression automatically). See: http://www.postgresql.org/docs/faqs/FAQ.html#4.5
-Neil
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
John Ossmann wrote: I'm not sure where to find it exactly, but does anyone know how much data a column of type "text" in a postgres DB can hold?
it's in the manual, in the Data Types section. the manual says "around 1GB".
btw, TEXT is one of those postgres-specific features that makes you
stick (stuck? :-) with postgres. nowadays, i never ever have to bother
to think whether to give a column a max width of 32, 50, 64, 100, 150,
.... is that a bad thing?
--
dave
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Oct 19, 2004, at 1:14 AM, David Garamond wrote: btw, TEXT is one of those postgres-specific features that makes you stick (stuck? :-) with postgres. nowadays, i never ever have to bother to think whether to give a column a max width of 32, 50, 64, 100, 150, ... is that a bad thing
I don't think it is a bad thing. Unless there is a clear and specific
limit related to the domain, why create one? You can create a last name
field with 20, 30, or 50 characters but there are no rules in the world
that will ensure you picked the right limit.
I guess it is only a bad thing if you have to consider porting your
PostgreSQL database. Hopefully it won't ever happen :).
Best,
John DeSoi, Ph.D. http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jukka K. Korpela |
last post by:
No, I'm not making this up, this is what http://www.w3.org/ says when
accessed with a text browser, or in any decent browser in no-images
mode:
"Tim Berners-Lee smiling 2003-12-31: Buckingham Palace today announced
that Queen Elizabeth II will make Tim Berners-Lee, W3C Director, a
Knight Commander of the Order of the British Empire (KBE)."
Actually, I could see the point of title="Tim Berners-Lee smiling",
since it's not obvious to...
|
by: David D. |
last post by:
Does the file extension matter when including a JavaScript file in an HTML
page?
Normally, one would include a JavaScript file in an HTML page using
<script src="foo.JS" type="text/javascript">
However, I have found that I can use an alternate file extension, such as
<script src="foo.HTML" type="text/javascript">
It works fine with my IE 6 and Mozilla. Will it work with other browsers?
|
by: Jon Davis |
last post by:
I recently learned how to do an <OBJECT> alternative to <IFRAME> in current
browsers using:
<object id="extendedhtml" type="text/html" data="otherpage.html" width="250"
height="400"></object>
My question is how do I access the document DOM of this object in
Javascript? For example, "alert(extendedhtml.innerHTML);" doesn't work and
produces an unknown error. I'd like to both read and write to the document's
body element's innerHTML...
|
by: Kivak Wolf |
last post by:
Hey everyone,
I have a textbox in my web page that is going to be used to enter an
E-mail into (just plain text, no HTML). Now, this will interact with a
SQL database where the contents of the textbox are sent from the SQL
database to the textbox, then the user edits it, and then the text
inside the textbox is sent back to the SQL database.
I did it the same way as if i had used a VarChar instead of a type
"text" variable in the SQL...
|
by: Linda |
last post by:
Hi,
Is there a way to do a "text" (rather than "binary") compareison with
the "like" operator, without changing the global "Option Compare"
setting? I don't want to risk breaking many, many lines of functional
code just to get one "like" operation to behave as I wish.
I want to check whether a single-character string is (a letter or
number, INCLUDING diacritical letters) or whether it is (something
else.)
| |
by: gabon |
last post by:
I'm creating a select entirely through JavaScript and very strangely IE
doesn't show the text in the option elements.
Here part of the code:
this.form_country=document.createElement("select");
var option;
for(var i=0; i<arr.length; i++){
option=document.createElement("option");
option.value=arr.code;
|
by: tilt |
last post by:
Hello,
I use an object element to replace the iframe element in ie, like this:
<object
id="x_obj"
data="http://.../"
type="text/html">
<iframe name="x_if" id="x_if" src="http://.../">
|
by: Navodit |
last post by:
Hi
I am new to Javascript and am not sure what is the difference between the
following two statements:
<script type="text/javascript">
.....
</script>
|
by: joe |
last post by:
Is it OK to have multiple:
<script type="text/javascript" src="funcs1.js"></script>
<script type="text/javascript" src="funcs2.js"></script>
<script type="text/javascript" src="funcs3.js"></script>
?
And I need to use similarly multiple CSS:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |