Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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??
Thank you,

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


/ /

/ /


pgsql-admin by date

Next:From: LSanchezDate: 2004-05-26 15:25:03
Subject: Re: pg_hba.conf
Previous:From: Bruce MomjianDate: 2004-05-26 15:12:54
Subject: Re: Postgresql Bulk Loading

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group