Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3A3242E072B for ; Tue, 13 Nov 2007 12:08:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 12543-06 for ; Tue, 13 Nov 2007 12:08:19 -0400 (AST) Received: from mail.int.journyx.com (mail.journyx.com [66.219.41.227]) by postgresql.org (Postfix) with ESMTP id B0A202E106F for ; Tue, 13 Nov 2007 12:08:19 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id 710053F236D for ; Tue, 13 Nov 2007 10:08:18 -0600 (CST) X-Virus-Scanned: amavisd-new at Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VPH4Yp1fe8Pl for ; Tue, 13 Nov 2007 10:08:12 -0600 (CST) Received: from whitneys (dhcp-100-201.int.journyx.com [192.168.100.201]) by mail.int.journyx.com (Postfix) with ESMTP id 7FB9F3F2316 for ; Tue, 13 Nov 2007 10:08:12 -0600 (CST) From: "Scott Whitney" To: Subject: Re: Help with command syntax? Date: Tue, 13 Nov 2007 10:08:16 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 In-Reply-To: <658CC899-491C-4388-B440-23422C30D9D2@indiana.edu> Thread-Index: AcgmDq6Ox8u8/LfeQqC8HYUWmY97AwAAJNog Message-Id: <20071113160812.7FB9F3F2316@mail.int.journyx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/100 X-Sequence-Number: 27343 select datid from pg_stat_database where datname='km'; select database_size(that_id); -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Walter Sent: Nov 13, 2007 9:35 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Help with command syntax? 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