X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C87F056458; Wed, 2 Mar 2005 16:38:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17343-09; Wed, 2 Mar 2005 16:38:00 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 10E7356444; Wed, 2 Mar 2005 16:38:00 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j22Gc0XO019607; Wed, 2 Mar 2005 16:38:00 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j22GOQrh015643; Wed, 2 Mar 2005 16:24:26 GMT (envelope-from news) From: "Greg Patnude" X-Newsgroups: pgsql.admin,pgsql.general Subject: Re: Database Name Date: Wed, 2 Mar 2005 08:25:31 -0800 Organization: dataMosaics.com Lines: 32 Message-ID: References: Reply-To: "Greg Patnude" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response To: "pgsql-admin@postgresql.org.pgsql-general"@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/30 X-Sequence-Number: 16528 "Envbop" wrote in message news:cvvvs3$1fli$1@news.hub.org... > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page > written > in php. > Its running on a Linux box. > The front end was also written in php. The original writers of this > application is no longer. > > I've just started to get familiarisd with postgresql in the last week. and > have installed PostgreSQL v8.0.1 on a Windows server. > And I am trying to connect to the linux box via the phppgadmin tool. as > well > as trying an odbc connection. > > Can someone tell me where I can find the database names. > > FWIW: phppgAdmin is a good interface if you ONLY have web-based access to the database.... if you need a real functionality -- I recommend pgAdmin III -- much more functional and feature rich with a better interface and the ability to extract SQL the constructs used to create the tables, etc....