The Developer Space

All things Developer

  • Cloud
  • Database
  • Open Source
  • Programming
  • Web Dev
  • Mobile
  • Security
  • QuickRef
  • Home
  • Database
  • Generated Columns in PostgreSQL

Generated Columns in PostgreSQL

Shameel Ahmed - CodeProject, Database, Open Source, PostgreSQL
September 18, 2019September 21, 2019 No Comments
0 0
Read Time45 Second

A generated column or a computed column is to columns what a view is to a table. PostgreSQL uses the term ‘Generated’ columns for Computed columns. The value of the column is always computed or generated from other columns in the table. A generated column can either be virtual or stored. The values for virtual columns are computed on the fly during query time and they don’t take storage space. The values for stored columns are pre-computed and stored as part of table data.

Read my full CodeProject article here.

More Reading

PostgreSQL 12: New Features and Enhancements
PostgreSQL finally gets Stored Procedures

Share

Facebook
Twitter
LinkedIn
Email

Post navigation

PostgreSQL 12: New Features and Enhancements
New Features and Enhancements in .NET Core 3.0

Related Articles

Migrating your SQL Server Workloads to PostgreSQL

Book: Migrating your SQL Server Workloads to PostgreSQL

Shameel Ahmed
May 5, 2020May 26, 2020 No Comments

Minimize Non-Critical Database Workload costs in AWS

Shameel Ahmed
April 23, 2020April 24, 2020 4 Comments
.NET Core Logo

New Features and Enhancements in .NET Core 3.0

Shameel Ahmed
September 25, 2019October 8, 2019 1 Comment

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
(Add your review)

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

.NET Architecture ASP.NET AWS Azure Books C# Cloud CodeProject Database Data Security Facade Java Mobile Open Source Patterns PostgreSQL Programming Security SQL Server Tools Uncategorized Web Development Windows Phone

Recent Posts

  • Book Review: Dealing with Difficult People (HBR Emotional Intelligence Series) September 14, 2020
  • MYSWP – Book Links May 25, 2020
  • Book: Migrating your SQL Server Workloads to PostgreSQL May 5, 2020
  • Minimize Non-Critical Database Workload costs in AWS April 23, 2020
  • C# 8 New Features October 8, 2019

Archives

  • September 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • October 2019 (1)
  • September 2019 (4)
  • July 2019 (2)
  • May 2018 (1)
  • September 2017 (1)
  • April 2017 (1)
  • April 2014 (1)
  • August 2011 (1)
  • June 2009 (1)
Copyright 2020. The Developer Space | Theme: OMag by LilyTurf Themes
  • DbStudio
  • shameel.net
  • Privacy Policy
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.