CREATING A NEW TABLE You can create a new table by specifying the table name, along with all column names and their types. Syntax for table creation: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, columnN datatype, PRIMARY KEY (one or more columns) ); An example for creating table on weather… Read More
Installation of PostgreSQL Linux using Source Code: To begin, connect to the Linux virtual Machine via PuTTY using IP address. To obtain the IP address, log into the virtual machine and enter the command ‘ifconfig’ in the terminal. Now open Putty and enter the IP… Read More
Guide to Installing VirtualBox on Windows for Running Linux Virtual Machines: If you’re a Windows user, who wants to learn PostgreSQL on a Linux Platform, one of the best solutions is to use Linux virtual machines in VirtualBox. In this article, we’ll guide you through… Read More
Introduction to PostgreSQL • PostgreSQL (pronounced as post-gress-Q-L) is a high demand open-source object relational database management system (ORDBMS). It was developed by a worldwide team of volunteers. It is not controlled by any private entity so, it is available for free. • PostgreSQL uses… Read More
PostgreSQL Articles Dear Readers, Please check the below list of PostgreSQL Articles SNo Description Link 1 Installation of PostgreSQL 11.4 On Windows Platform https://www.ktexperts.com/installation-of-postgresql-11-4-on-windows-platform/ 2 How to Download and Install the pgAdmin 4 https://www.ktexperts.com/how-to-download-and-install-the-pgadmin-4/ 3 Installation of PostgreSQL 11.4 in Linux Platform. https://www.ktexperts.com/installation-of-postgresql-11-4-in-linux-platform/ 4 Install… Read More
PostgreSQL Interview Q&A Part-3 Before going into the article, please check our previous article on PostgreSQL Q&A Part-2 1. Can we have different data directories for PostgreSQL Cluster? Under One PostgreSQL installation, you can create multiple Clusters. Each Cluster will have its own data directory. One… Read More
Hello Everyone, This article will help you learning basic commands in postgreSQL. Psql is an interactive terminal to work with the PostgreSQL database. It is used to retrieve data from the PostgreSQL database server faster and more effectively. The below commands are very helpful for… Read More
Tablespace Administration in Postgres – Q&A 1. What is tablespace in Postgres? A. It specifies in which location contents of the tables should be stored. We can’t use a database without tablespace Default tablespace is pg_default Users while creating objects can specify on which tablespace… Read More
PostgreSQL Interview Q&A Part-2 Before going into the article, please check our previous article on PostgreSQL Q&A Part-1 1. What are template0 & template1 databases? As the name suggests, these are template databases that come by default with the Installation. In a fresh installation, both… Read More
PostgreSQL Interview Q&A Part -1 PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance. The frequently asked questions from PostgreSQL database are given below. 1.Difference between Alert log in Oracle and Error log in PostgreSQL? Error log to PostgreSQL is… Read More
