![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
The following bug has been logged online: Bug reference: 2465 Logged by: Patrick Hayes Email address: pkhayeskp (AT) hotmail (DOT) 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. |

#3
| |||
| |||
|
|
From: "Jim C. Nasby" <jnasby (AT) pervasive (DOT) com To: pat hayes <pkhayeskp (AT) hotmail (DOT) com CC: pgsql-bugs (AT) postgresql (DOT) org Subject: Re: [BUGS] BUG #2465: Installation Date: Thu, 8 Jun 2006 17:02:28 -0500 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 (AT) pervasive (DOT) com To: Patrick Hayes <pkhayeskp (AT) hotmail (DOT) com CC: pgsql-bugs (AT) postgresql (DOT) 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 (AT) hotmail (DOT) 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 (AT) pervasive (DOT) 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 (AT) pervasive (DOT) com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 |
![]() |
| Thread Tools | |
| Display Modes | |
| |