Category: PostgreSQL

A category for PostgreSQL related articles.

Categories
MySQL PostgreSQL

Concat two strings in postgreSQL and MySQL

Default featured post
Default featured post

Recently, I have faced with the situation that I had to update one column value with the combination of two strings (one is another column string and the other one is a single word) for entire table. One way is to update each row manually but what if there are millions rows to update? In […]

Categories
PostgreSQL

Connecting to remote Postgresql database with SSH tunnelling

Default featured post
Default featured post

In this post I discuss about how to connect to remote Postgresql database  with SSH tunneling. Basically, with SSH you are capable to do almost whatever  that you can do with a normal computer including, port forwarding, X forwarding, audio and video forwarding and many other awesome things. Therefore, connecting to remote postgres database should […]

Exit mobile version