table check

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: table check
Date: 2004-05-26 15:14:00
Message-ID: 40B4B438.2060900@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We are working on checking to see whether a database has been created
from a Perl/Pg interface. Is there an easy way to count tables such
that if the count comes back at zero the script knows that the database
has not yet been created?
We tried simply using \d but cannot get that to work. I would assume
there is some system table that must list the tables when there are some??
thoughts?
Thank you,
Jodi
--

/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>/

/ /

/ /

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message LSanchez 2004-05-26 15:25:03 Re: pg_hba.conf
Previous Message Bruce Momjian 2004-05-26 15:12:54 Re: Postgresql Bulk Loading