Dblinks provide to connect another databases. Also you can do DML operations with using dblink. I will use dblink to connect two PostgreSQL databases on this post. Also I will tell how to use select, update and delete with dblink. Firstly, you have to create dblink entension with related user which is using dblink. Create…
Category: Errors and Solutions
ERROR: database “database_name” is being accessed by other users in PostgreSQL
Error When you execute drop database command, database get an error like ERROR: database “database_name” is being accessed by other users.> Solution
PostgreSQL Error : invalid byte sequence for encoding utf8
Error PostgreSQL Error : invalid byte sequence for encoding UTF8 When I try insert a row with Turkish character, I get an error like above. Solution