Re: table size

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of David Blood
Sent: Wednesday, March 06, 2002 4:44 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] table size

Yes

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Doug McNaught
Sent: Wednesday, March 06, 2002 7:41 AM
To: David Blood
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] table size

"David Blood" <davidjblood(at)yahoo(dot)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(at)postgresql(dot)org