Category: Postgresql

PostgresQL is an object-relational database management system (ORDBMS) based on version 4.2 of POSTGRES developed by the Department of Computer Science at the University of California, Berkeley. It has now been renamed to PostgreSQL. PostgreSQL supports most SQL standards and provides many other modern features: complex queries, foreign keys, triggers, views, transaction integrity, MVCC. Similarly, PostgreSQL can be extended in many ways, for example, by adding new data types, functions, operators, aggregate functions, and indexes. Use, modify, and distribute PostgreSQL for free, whether it is for private, commercial, or academic research.

PostgreSQL – PGADMIN 4 (or DB VisualiSer) Entity Relationship

How to use pgAdmin v4 or DB Visualizer or any other open source tools to make entity relationship diagrams?

PG Administrator
pgadmin III has many interpreters, but they suggest that there sho

September 21, 2021By Simo Postgresql DB, diagram, entity, PGADMIN, PostgreSQL, relationship, VisualiserLeave a Comment

PostgreSQL-9.1 – PgAdmin III does not respond when trying to recover the database

I am trying to restore the database (via a backup file), I am using PgAdmin III (Postgresql 9.1).
After selecting the backup file, a window indicates that pg_restore.exe is running, and then PgAdm

September 21, 2021By Simo Postgresql 9.1, database, III, no, PGADMIN, PostgreSQL, recovery, response, tryLeave a Comment

In vs Any operator in PostgreSQL

What is the difference between the IN and ANY operators in PostgreSQL?
The working mechanism of the two seems to be the same. Can anyone explain this with an example? Logically, quoting the manu

September 21, 2021By Simo Postgresql Medium, operator, PostgreSQL, VSLeave a Comment

Build a Python3 Auth Proxy Server between PostgreSQL and Dynamics 365 Web API

After a few days of some progress, I accepted the fact that I lacked knowledge or skill level, put all these parts together and completed this project. Therefore, I am very helpful to anyone I am w

September 21, 2021By Simo Postgresql Agent, API, Auth, between, building, Dynamics, PostgreSQL, python, Python3, server, WEBLeave a Comment

PostgreSQL10 Configure Remote Connections

PostgreSQL10 configuration remote connection psql — version

# TYPE DATABASE USER ADDRESS METHOD

# “local” is for Unix domain socket connections only
local all all peer
# IPv4 local connecti

September 21, 2021By Simo Postgresql configuration, connection, PostgreSQL, PostgreSQL10, remoteLeave a Comment

PostgreSQL – PG_UPGRADE tool failed: invalid “unknown” user column

The Postgresql update from 9.6 to 10.4 (on Fedora 28) confuses me: a table in a database has a column of data type “unknown”. I am happy to delete the column , But because I cannot start the postgr