Re: BUG #2465: Installation

See \? in psql. In particular, \d. Note that a plain '\d' won't show you
tables that aren't in your search_path.

On Wed, Jun 07, 2006 at 09:53:03AM -0500, pat hayes wrote:
> Jim,
>  Thank you for your help.  I have two last questions.  How do you get the
> system to describe a table? How to you get the system to give a listing of
> all the table that a user has in his scheme?  Thanks again for all the help.
>
>                       PAT
>
>
> >From: "Jim C. Nasby" <jnasby@pervasive.com>
> >To: Patrick Hayes <pkhayeskp@hotmail.com>
> >CC: pgsql-bugs@postgresql.org
> >Subject: Re: [BUGS] BUG #2465: Installation
> >Date: Tue, 6 Jun 2006 17:40:39 -0500
> >
> >On Fri, Jun 02, 2006 at 07:47:02PM +0000, Patrick Hayes wrote:
> >>
> >> The following bug has been logged online:
> >>
> >> Bug reference:      2465
> >> Logged by:          Patrick Hayes
> >> Email address:      pkhayeskp@hotmail.com
> >> PostgreSQL version: 8.1
> >> Operating system:   Window XP
> >> Description:        Installation
> >> Details:
> >>
> >> I have installed version 8.1.  I am trying to access the console.  This
> >will
> >> not allow me access.  I know I am entering the correct password.
> >
> >I'd bet that you're not. :)
> >
> >I suggest going into pg_hba.conf and enabling trust access. Then connect
> >and change the password and change pg_hba.conf back. You'll need to
> >reload the config after each pg_hba.conf change.
> >--
> >Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> >Pervasive Software      http://pervasive.com    work: 512-231-6117
> >vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461