Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C9DBA2E16F8 for ; Tue, 13 Nov 2007 12:21:11 -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 79292-02 for ; Tue, 13 Nov 2007 12:17:39 -0400 (AST) Received: from xgate.rdw.ru (xgate.rdw.ru [213.219.232.34]) by postgresql.org (Postfix) with ESMTP id EDB4B2E156A for ; Tue, 13 Nov 2007 12:17:38 -0400 (AST) Received: (qmail 19627 invoked from network); 13 Nov 2007 16:17:37 -0000 Received: from unknown (HELO senoval.rdw.ru) ([192.168.0.57]) (envelope-sender ) by xgate.rdw.ru (qmail-ldap-1.03) with DES-CBC3-SHA encrypted compressed SMTP for ; 13 Nov 2007 16:17:37 -0000 Received: (qmail 3994 invoked from network); 13 Nov 2007 16:17:36 -0000 Received: by simscan 1.2.0 ppid: 3989, pid: 3990, t: 0.0264s scanners:none Received: from unknown (HELO ART-555) ([192.168.22.117]) (envelope-sender ) by senoval.rdw.ru (qmail-ldap-1.03) with SMTP for ; 13 Nov 2007 16:17:36 -0000 Date: Tue, 13 Nov 2007 19:17:45 +0300 From: isk X-Mailer: The Bat! (v3.80.06) Professional Reply-To: isk Organization: RDW X-Priority: 3 (Normal) Message-ID: <1207689533.20071113191745@rdw.ru> To: Carol Walter CC: pgsql-admin@postgresql.org Subject: Re: Help with command syntax? In-Reply-To: <658CC899-491C-4388-B440-23422C30D9D2@indiana.edu> References: <658CC899-491C-4388-B440-23422C30D9D2@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.377 tagged_above=0 required=5 tests=AWL=1.080, BAYES_40=-0.185, DNS_FROM_RFC_BOGUSMX=1.482 X-Spam-Level: ** X-Archive-Number: 200711/102 X-Sequence-Number: 27345 select pg_database_size('km'); select pg_size_pretty(pg_database_size('km')) as size; > Greetings, > Can someone help me with the syntax for running a postgres function =20 > from the within psql? I need to know the size of several databases. =20 > The postgres documentation says there is a function that will do what =20 > I need. The function is pg_database_size(name). I tried select =20 > pg_database-_size(km). The response I get says there is no column =20 > "km". I think I must be using the wrong syntax, but haven't found a =20 > 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 --=20 =D1 =F3=E2=E0=E6=E5=ED=E8=E5=EC, isk mailto:isk@rdw.ru