I have postgres 7.2. I have a web page that uses coldfusion scripting to
insert the contents of a form into a table. One of the items on the form is
a place to put comments. To insert the data into the table, I used cold
fusion's url encode which converts all not alpha text into their hex values.
IE: spaces gets converted to %20 and so on. It seemed like a good idea to
avoid having to attempted to catch for ' or " that may be entered into the
comment until I got an error saying the query string was too long. Is there
a limit in postgres on how long the query string can be?
Thank You
Charles Cruise
System Administrator
RV America OnLine
www.rvamerica.com
408 E. Southern Avenue
Tempe, Az 85282
480-784-4771
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of David Blood
Sent: Wednesday, March 06, 2002 4:44 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] table size
Yes
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Doug McNaught
Sent: Wednesday, March 06, 2002 7:41 AM
To: David Blood
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] table size
"David Blood" <davidjblood@yahoo.com> writes:
> I have noticed that our database is growing in size about 10 MB day.
I
> am not sure where this growth is coming from. Is there an easy way to
> check the size of all of the tables?
Are you running VACUUM regularly?
-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/
Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org