Re: How do I enabled Windows 10 to be able to run PSQL etc

On Mon, Sep 9, 2019 at 6:07 AM Karen Goh <karenworld(at)yahoo(dot)com> wrote:

> Hi Rob,
>
> I refer to your comment -
> I think you need to add “membership” to your pgadmin connection string.
>
> How do I add in the pgadmin connection string at pgAdmin4 ?
>
> Before that, I was creating table using the sql script in version 10 and
> there was no problem at all.
>
> So, it really baffled me it is not working out this time.
>
> And tomorrow I have an important demo and it seems that I have to take out
> this table in my app to show...which will be less impressive in a not so
> impressive app that i have created ....:(
>
> I have made some more screenshots which shows some more error when I tried
> to retrieve the table under the table postgres which is already created not
> it is not showing the table.
>
> Please help,
>

Your second screenshot seems to indicate your connection between PgAdmin
and Pg 11 Server is broken in some ways. If I were taking over the keyboard
at your workstation and had a critical deadline for tomorrow, here are some
steps I would take:

- Dump my databases, if I can
- Backup whatever work I have on a usb stick (create sql files, etc)
- Uninstall Pg Server and Pg Admin
- Reinstall and see if things start working better

Then on more detailed level, my understanding of Postgres is that when you
prefix a word in front of a table you are referring to a schema so
create table membership.parents...

Will never work unless you first create the schema
<https://www.postgresql.org/docs/current/sql-createschema.html>that parents
sit within:
create schema membership

Is it possible your problem is that you aren't creating membership schema
in your database? (Postgres treats schemas in much the same way that other
database engines treat actual databases).

Finally, if you are desperate for a working Pg SQL server over the next 24
hours consider spinning up an AWS RDS Pg instance and connecting PgAdmin to
that - that way you know the database is reliable and correctly configured
for sure. There might even be a "free tier" that gives you free service for
that time frame..

Steve