Tags » PostgreSQL

psql on bash on Windows

1. Windows 10 supports Subsystem for Linux.
2. psql has some issues with non-English locales under Windows, see Notes for Windows Users.

So I installed WSL, then choose Ubuntu, started Bash and executed: 26 more words


IsEven or IsEvenER?

Recently friend of mine sent me a funny picture:

Cool, ha?! 290 more words


PostgreSQL Server SSL Setup

When I was first asked to encrypt my postgres DB connections I had no idea where to start.

I needed to learn more about SSL. So I spent a few nights reading blogs and creating CAs and certs to secure a simple nginx website with SSL on one of my VBox VMs. 409 more words


Cara mudah melihat session database PostgreSQL

Bagi Anda yang menggunakan database PostgreSQL sebagai penyimpanan data aplikasinya, berikut ini adalah perintah atau cara mudah untuk melihat session database yang sedang berjalan : 120 more words


query to find whether an object is table or view in postgresql

Postgresql has a default schema named information_schema, which consists of a set of views, that contain information about the objects defined in the current database. 27 more words


Hackers and Bugs lists migration and GMail's filters

Hackers and Bugs are heavy loaded lists. So it’s wise to turn notification off for them. This may be done using Gmail’s filters. “Mark as Read” is the key to success. 190 more words