Re: Database issues when adding GUI - Mailing list pgsql-general

On Mon, 7 Jun 2021, Philip Semanchuk wrote:

> I agree with Rich. Permissions, or you’re connecting as the wrong user.
> You might find it helpful to simplify and not use a GUI application until
> you get your connection issues sorted out. A simple command line Python
> app that connects to the database and prints the result of “select * from
> activitytypes limit 1” will enable quick(er) debugging of your connection
> issues.

Philip,

I've used the psql shell for years. That's not a GUI.

bustrac=# select * from activitytypes;
   act_name 
------------
  Phone
  Email
  Fax
  Meeting
  Conference
  Referral
  Called me
  Other
(8 rows)

Rich