table check - Mailing list pgsql-admin

From Jodi Kanter
Subject table check
Date
Msg-id 40B4B438.2060900@virginia.edu
Whole thread Raw
Responses Re: table check  (Bruno Wolff III <bruno@wolff.to>)
List 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@virginia.edu


 

 

 

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_hba.conf
Next
From: Bruce Momjian
Date:
Subject: Re: Postgresql Bulk Loading