ERROR: column “…” does not exist
PostgreSQL internally converts all column and table names to lowercase when executing the SQL query. If the column or table name contains uppercase letters, we need to use double quotes to be able to reference them. When we get the error message ERROR:…
PostgreSQL management tools
Install the PostgreSQL Server and the pgAdmin user interface To install the latest PostgreSQL server and the pgAdmin user interface To install pgAdmin only pgAdmin is a browser based database management tool for PosgtreSQL databases. It does not install…
Error loading table definition of a PostgreSQL table
When a PostgreSQL table name contains uppercase letters there is no known way to get the table definition SQL script. When we right-click a table name in SQLPro for Postgres, and the column name has an uppercase letter and select Script as, CREATE to,…
Reverse engineer a database with AspNetCore in Visual Studio
For some reason the .NETCore designers did not think, that developers want to follow best practices by separating the data layer from the presentation layer. The Entity framework out of the box only works if the database is accessed from the main…