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

PostgreSQL

IsEven or IsEvenER?

Recently friend of mine sent me a funny picture:

Cool, ha?! 290 more words

PostgreSQL

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

PostgreSQL

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

PostgreSQL

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

Information_schema

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

PostgreSQL