Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g11Dxml69457 for ; Fri, 1 Feb 2002 08:59:49 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id g11DYjg55842 for pgsql-sql@postgresql.org; Fri, 1 Feb 2002 08:34:45 -0500 (EST) (envelope-from news) From: "Steve Brett" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: test the existence of a database Date: Fri, 1 Feb 2002 13:29:36 -0000 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 22 Message-ID: References: X-Complaints-To: news@hub.org X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 To: pgsql-sql@postgresql.org X-Archive-Number: 200202/4 X-Sequence-Number: 6436 psql -l will list the databases. psql will give to access to the command line sql environment and once you're in there /dt will list the tables ... Steve "D'laila Pereira" wrote in message news:Pine.GSO.4.31.0201311451080.6396-100000@ux11.cso.uiuc.edu... > > After a database is created in postgresql using the createdb command, > and populate it with some taqbles, how do we test the existence of the > database and the tables within it? > > thanks > d'laila > >