All PostgreSQL Articles

This page is a page which contain all articles about PostgreSQL Database and all things related on it. The content of this page will continue on available with updates and modifications. Those updates and modifications will be exist in this page as a new link to the articles. Off course, the articles will contain the subject on PostgreSQL Database Server.

PostgreSQL Installation

1. How to Install PostgreSQL 9.6 on Ubuntu Linux

2. How to Install PostgreSQL 10.4 on Ubuntu 16.04

3. How to Install PostgreSQL Database Server using compressed file in CentOS 8

4. How to Create a Service Script for PostgreSQL Database Server in Linux

PostgreSQL Data Initialization

How to Initialize PostgreSQL Database in Linux

PostgreSQL Database Server Service

1. How to Start PostgreSQL Database Server manually in Linux

2. How to Start PostgreSQL Database Server manually using postgres command in Linux

3. How to Start PostgreSQL Database Server using pg_ctl execution in Linux

4. How to Start PostgreSQL Database Server in Linux using Service Script

5. How to Stop PostgreSQL Database Server Manually in Linux

6. How to Stop PostgreSQL Database Server using pg_ctl execution in Linux

7. How to Stop PostgreSQL Database Server in Linux using Service Script

PostgreSQL SQL Query Command related with User Management

How to Create User in PostgreSQL Database Server

PostgreSQL SQL Query Command related with Role Management

1. How to Create Role in PostgreSQL Database Server

2. How to Create Role in PostgreSQL with Password

PostgreSQL SQL Query Command related with View Management

1. How to Show All View in PostgreSQL Database Server

2. How to Change Owner of a View in PostgreSQL Database Server

PostgreSQL SQL Query Command related with Sequence

1. How to Show or to List available Sequence in PostgreSQL Database Server

2. How to Create a Sequence in PostgreSQL Database Server

PostgreSQL SQL Query Command related with Table

1. How to Create a Table in PostgreSQL with an auto-increment

2. How to Create a Table in PostgreSQL with an auto-increment using Sequence

3. How to Describe the Table in a PostgreSQL Database Server

4. How to Rename Table in PostgreSQL Database

5. How to Alter Table in PostgreSQL Database by Adding a New Column

6. How to Alter Table in PostgreSQL Database by Adding a New Column with a Default Value

7. How to Add Foreign Key Constraint in PostgreSQL Database

8. How to Count Rows in PostgreSQL

9. Display Available Tables in PostgreSQL

10. How to Show Table Structure using Query in PostgreSQL Database Server

PostgreSQL SQL Query Command related with Role

How to Add Role Attribute for User in PostgreSQL Database

PostgreSQL SQL Query Command related with Schema

1. How to Grant All Privileges for a Specific Schema in PostgreSQL Database

2. How to Change the owner of a schema in PostgreSQL

3. How to Grant All Privileges to All Tables in a Certain Schema in PostgreSQL

4. How to Change the Current Working Schema in PostgreSQL Command Line

5. How to Check Default Current Active Working Schema in PostgreSQL Database Server

6. How to Change Default Current Active Working Schema Permanently in PostgreSQL Database Sever

PostgreSQL SQL Query Command related with Column in a Table

1. How to Rename Column in PostgreSQL Database

2. How to Rename Column in a Table in PostgreSQL Database Server

3. How to Change the Type of the Column in a Table in PostgreSQL Database Server

4. How to Describe a table in PostgreSQL

5. How to Add Column of a Table in PostgreSQL Database

PostgreSQL SQL Query Command related with Database

1. How to List All Database in PostgreSQL via Command Line. Another similar article exist with the title of ‘List available databases in PostgreSQL‘.

2. Select Database PostgreSQL

3. PostgreSQL Database Access from Command Line in Linux

4. How to Grant All Privileges in PostgreSQL Database

5. How to Force Drop PostgreSQL Database in PostgreSQL Database Server

PostgreSQL SQL Query Command related with Backup Process Management

1. How to Dump PostgreSQL Database

2. How to Dump All View in PostgreSQL Database Server

3. Backup Database PostgreSQL Command Line

4. Create User for dumping database PostgreSQL

5. Dumping PostgreSQL Database into File via Command Line

6. Dumping PostgreSQL Database into File with Date Attribute

7. Create Daily Backup PostgreSQL Database using Cron in Linux

8. Export PostgreSQL Table to csv via Command Line

9. How to Run SQL File into a Specific Schema in PostgreSQL Database Sever

PostgreSQL SQL Query Command related on Timezone

1. Set Timezone in PostgreSQL using Query

2. Show timezone in PostgreSQL Database Server

PostgreSQL SQL Query Command and Other Article

1. How to Check PostgreSQL Database Server’s service status.

2. How to Check PostgreSQL Database Server’s version via Command Console.

3. How to Access PostgreSQL Database Server via Command Line.  Another similar article exist with the title of ‘Connecting to PostgreSQL Database via Linux Shell Command‘. Another one with a similar content with the title of ‘Connect to PostgreSQL command line Linux‘.

4. How to Show Current Database in PostgreSQL Database Server via PostgreSQL Command Console.

5. How to Show Current User in PostgreSQL Database Server via PostgreSQL Command Console.

6. How to Show Available User in PostgreSQL Database Server via PostgreSQL Command Console.

7. How to Show Available User with Role in PostgreSQL Database Server via PostgreSQL Command Console.

8. How to Access PostgreSQL without Password.

9. Change postgres Password via Command Line

10. How to Check PostgreSQL Version via Command Console

11. How to print output for each field in a row using the PostgreSQL Command

PostgreSQL Solving Error Message

1. How to Solve Error Message no database directory specified and environment variable PGDATA unset when starting PostgreSQL Database Server in Linux

2. How to Solve Error Message postgres does not know where to find the server configuration file when Starting PostgreSQL Database Server in Linux

3. How to Solve configure: error: readline library not found when Installing PostgreSQL

4. How to Solve Error Message pg_ctl: no operation specified when starting PostgreSQL database server using pg_ctl

5. How to Solve Error Message pg_ctl: no database directory specified and environment variable PGDATA unset when starting PostgreSQL database server using pg_ctl

6. How to Solve Error Message ERROR: permission denied to create database in PostgreSQL Database