PostgreSQL

External Article

PostgreSQL Constraints: Learning PostgreSQL with Grant

  • Article

One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data.

2023-03-22

External Article

PostgreSQL Basics: Roles and Privileges

  • Article

Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often referred to as AuthN and AuthZ respectively. Likewise, PostgreSQL security involves creating roles that allow access to server resources (AuthN) and then granting privileges to database objects appropriately (AuthZ). Understanding how each of these components work together is essential to effectively manage security in a PostgreSQL cluster.

2023-02-22

SQLServerCentral Article

PostgreSQL Triggers Part 2

  • Article

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

You rated this post out of 5. Change rating

2022-09-23

1,211 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

Indexing strategy very long text strings

By aaron.reese

Hey guys,  Just looking to see if anyone has any bright ideas how to...

Visit the forum

Question of the Day

Logical Operators

I have this table and data:

CREATE TABLE ProdList
(ProductID INT NOT NULL
, ProductName VARCHAR(100)
, ProductCategory VARCHAR(40)
, ProductSize VARCHAR(4)
, ProductColor VARCHAR(20)
)
GO
INSERT dbo.ProdList
  (ProductID, ProductName, ProductCategory, ProductSize, ProductColor)
VALUES
  (1, 'Dirt Bike', 'Bike', '26', 'Blue'),
  (2, 'Mtn Bike', 'Bike', '26', 'Red'),
  (3, 'Dirt Bike', 'Bike', '24', 'Blue'),
  (4, 'Downhill', 'Ski', '180', 'White'),
  (5, 'Telemark', 'Ski', '175', 'Blue'),
  (6, 'Snowboard', 'Ski', '182', 'Various'),
  (7, 'Goggles', 'Ski', 'L', 'Clear')
How many rows are returned from this code:
SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR pl.ProductCategory = 'Ski'
 AND pl.ProductColor = 'Red'

See possible answers