Charts In PostgreSQL

Photo by Choong Deng Xiang on Unsplash

Have you ever heard about Graph Visualiser in PostgreSQL? Yes, this feature was introduced in Pgadmin4 V6.12. Visualization of data in the query tool refers to the visual representation of data in the result set. The Graph Visualiser supports 5 types of Charts.

1. Line Chart

2. Stacked Line Chart

3. Bar Chart

4. Stacked Bar Chart

5. Pie-Chart.

Let’s see all charts in detail below.

We are going to use Student_details table to create all our charts.

Download the csv file Student_details and create a table Student_details

and then import the given csv file into the table by selecting the created table (Student_details) and choose import/export Data as like below screenshot.

Then choose the csv file which is downloaded from above link and click OK.

Now let’s try to create all the charts with the below data from Student_details table.

1. Line Chart:

Create a line chart to display all 3 subject marks of all students.

Result:

We get the below output. Then choose the Graph Visualiser circled in red as shown in the below screenshot.

Then choose Graph Type as Line Chart, X-Axis as student_name and Y-Axis as Select All and click Generate. Line Chart will generate automatically based on the output. See the below screenshot for your reference.

Line Chart for marks of all the students.

We can see any two students mark by selecting only those two students as like below screenshot. Ed Chase and Jennifer Davis details have chosen below.

The result will display for those two students (Ed Chase and Jennifer Davis) only as like below. Also, we can see mouse over the line and see the tool tip. To go back to original, click “Zoom to original” button which is near to download button.

Mouse over to the green line of Jennifer Davis and see the science mark as a tool tip.

2. Stacked Line Chart:

Create a stacked line chart to display marks of students.

Result:

Once you get the output then choose Graph Visualiser and choose Graph Type as Stacked Line Chart, X-Axis as student_name and Y-Axis as Select All and click Generate. Stacked Line Chart will generate automatically based on the output. See the below screenshot for your reference. It’s almost looks like an Area Chart.

Stacked line chart looks like Area Chart

3. Bar Chart:

Create a Bar Chart to display marks of all students.

Result:

Once you get the output then choose Graph Visualiser and choose Graph Type as Stacked Line Chart, X-Axis as student_name and Y-Axis as Select All and click Generate. Stacked Line Chart will generate automatically based on the output. See the below screenshot for your reference.

Bar chart for all subject marks for each student

4. Stacked Bar Chart:

Create a Bar Chart to display marks of all students.

Result:

Once you get the output then choose Graph Visualiser and choose Graph Type as Stacked Bar Chart, X-Axis as student_name and Y-Axis as Select All and click Generate. Stacked Bar Chart will generate automatically based on the output. See the below screenshot for your reference.

Stacked Bar Chart stacks all marks as a single Bar for each student.

5. Pie-Chart:

Create a Bar Chart to display marks of all students.

Result:

Once you get the output then choose Graph Visualiser and choose Graph Type as Pie-Chart, Label as student_name and Value as any subject (English has chosen here) and click Generate. Pie-Chart will generate automatically based on the output. See the below screenshot for your reference.

English marks for all the students displaying here as a Pie-Chart.

Conclusion:

Graph Visualiser are a supporting tool in PostgreSQL PgAdmin4 that allow you to visualize your output efficiently.

Thank you for reading. Happy learning!!!