-
How to Get Data from PostgreSQL in Python?
Hello! Today we will cover how to get data from PostgreSQL in Python topic. Python is a general purpose programming language widely used in data analysis and data science projects. These domains programming language used most, requires a lot of interaction between Python and database. In this article I will show you how to get…
-
How to View a Table in PostgreSQL?
Hello! Today we are here for a very simple question. How to view a table in PostgreSQL? I saw this question searched on Google around 50 times each month, and want to explain answer of the question. Well, question itself was not really clear, but i believe there can be two different options are available:…
-
How to: Postgres Parse JSON?
Hello! PostgreSQL has built in tools to parse JSON data. This is going to be a how to article about Postgres Parse JSON. I will show you how to parse a json using PostgreSQL. Let’s get back to work. Parsing a Simple JSON using PostgreSQL Let’s assume we have a very simple JSON as: If…
-
How to Create Database in Postgresql in Linux Terminal?
Hello! In this article we will talk about how to create a database in PostgreSQL in the Linux terminal. Psql is a terminal client we can use to manipulate database objects. For more information you can check Postgresql documentation for CREATE DATABASE statement. How to Create Database in Postgresql in Linux Terminal? First of all…
-
How to Check Active Sessions in PostgreSQL?
Hello! In this article we will cover how to check active sessions in PostgreSQL topic. What is a Session? A session is a connection. When you connect to your database using psql command line it is a session, or using dbeaver it is a session. Pooled Connection Sources I would like to put a separate…
-
How to Check DB Locks in Postgres
Hello! I was afraid of locks when I started to manage databases. It affects the performance and reliability of the database. In this article, I will cover how to check db locks in PostgreSQL topic. How to Check DB Locks in Postgres? Locks are indirect indicators of database health. Locks don’t point out a database…