Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4AD132E157F for ; Tue, 13 Nov 2007 12:13:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 74227-10 for ; Tue, 13 Nov 2007 12:13:03 -0400 (AST) Received: from cluster-j.mailcontrol.com (cluster-j.mailcontrol.com [86.111.223.190]) by postgresql.org (Postfix) with ESMTP id C32C52E072B for ; Tue, 13 Nov 2007 12:13:02 -0400 (AST) Received: from rly51j.srv.mailcontrol.com (localhost.localdomain [127.0.0.1]) by rly51j.srv.mailcontrol.com (MailControl) with ESMTP id lADGCtTX004173 for ; Tue, 13 Nov 2007 16:12:55 GMT Received: from submission.mailcontrol.com (submission.mailcontrol.com [86.111.216.190]) by rly51j.srv.mailcontrol.com (MailControl) id lADGC28Y030849 for pgsql-admin@postgresql.org; Tue, 13 Nov 2007 16:12:02 GMT Received: from jupiter.egsgroup.com (jupiter.egsgroup.com [217.199.182.198]) by rly51j-eth0.srv.mailcontrol.com (envelope-sender alexander.stanier@egsgroup.com) (MIMEDefang) with ESMTP id lADGBtVY030235; Tue, 13 Nov 2007 16:12:02 +0000 (GMT) Received: by jupiter.egsgroup.com (Postfix, from userid 65) id 7D53070E4; Tue, 13 Nov 2007 16:11:55 +0000 (GMT) X-Scanned-By: MailControl A-06-00-00 (www.mailcontrol.com) on 10.74.1.161 X-Scanned-By: AMaViS-ng at egsgroup.com Received: from [10.20.0.98] (unknown [217.150.127.117]) by jupiter.egsgroup.com (Postfix) with ESMTP id 90C92AF; Tue, 13 Nov 2007 16:11:54 +0000 (GMT) Message-ID: <4739CCC9.8080704@egsgroup.com> Date: Tue, 13 Nov 2007 16:11:53 +0000 From: Alexander Stanier Organization: EGS Ltd User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Carol Walter Cc: pgsql-admin@postgresql.org Subject: Re: Help with command syntax? References: <658CC899-491C-4388-B440-23422C30D9D2@indiana.edu> In-Reply-To: <658CC899-491C-4388-B440-23422C30D9D2@indiana.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.365 tagged_above=0 required=5 tests=AWL=0.364, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/101 X-Sequence-Number: 27344 You need to put the database name in single quotes: select pg_database_size('km'); Regards, Alex. Carol Walter wrote: > Greetings, > > Can someone help me with the syntax for running a postgres function > from the within psql? I need to know the size of several databases. > The postgres documentation says there is a function that will do what > I need. The function is pg_database_size(name). I tried select > pg_database-_size(km). The response I get says there is no column > "km". I think I must be using the wrong syntax, but haven't found a > reference to what the correct syntax is. > > Thanks, > Carol Walter > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > > This email has been scanned for viruses by Blackspider's Mail Control > System.For more information please visit http://www.blackspider.com This message has been scanned for malware by SurfControl plc. www.surfcontrol.com