Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9E9C19FB30F for ; Fri, 27 Oct 2006 12:22:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17536-02 for ; Fri, 27 Oct 2006 12:22:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id F15799FB25F for ; Fri, 27 Oct 2006 12:22:27 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id g2so1104231nfe for ; Fri, 27 Oct 2006 08:22:27 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sSrXGeqZfn82yYPVvtUqvlhKBFlWgJU/64FXlS0FZFVxncvPM6kzHiKy81FUFEXncJaZKnT7n7PDHp1XOfBpcVLkp7tQrc+6RyWTZD/v9blSHpNcLkS5U+3j3qcjtzB/jnsYNVps3me52MD1S60OIGBnRNJt8yAfhcWxrjKmTt0= Received: by 10.49.29.3 with SMTP id g3mr1115729nfj; Fri, 27 Oct 2006 08:22:25 -0700 (PDT) Received: by 10.48.215.19 with HTTP; Fri, 27 Oct 2006 08:22:25 -0700 (PDT) Message-ID: <4f4c2a010610270822j2c162d7bm19902412dd15cae3@mail.gmail.com> Date: Fri, 27 Oct 2006 11:22:25 -0400 From: "Jon Horsman" To: pgsql-sql@postgresql.org Subject: Re: How to query information schema from shell script In-Reply-To: <4f4c2a010610270812r65d321cejf00cb374596f2a5f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4f4c2a010610270631q73de201tb98446f64b942a0e@mail.gmail.com> <4f4c2a010610270657we83aa70o471678507d59c6a0@mail.gmail.com> <4f4c2a010610270812r65d321cejf00cb374596f2a5f@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.651 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/220 X-Sequence-Number: 26609 For more information, i know how this is done using the pg_catalog but have yet to find out how its done with the information schema. select * from pg_catalog.pg_database where datname='test' will work for me but i can't find a solution with the IS. I'd prefer to use the IS if its as easily done as with pg_catalog Jon