Medium
Consider the SQL statement below for creating a table with a constraint in PostgreSQL. Which option correctly adds a unique constraint on the email column while creating the users table?
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(255)
);
Author: abdelghaniStatus: PublishedQuestion passed 60 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar QuestionsMore questions about PostgreSQL
2
What is the mechanism in PostgreSQL that ensures the integrity of transactions and supports concurrent processing?1
What is the command to back up a database in PostgreSQL?1
What type of index is primarily used for full-text search in PostgreSQL?0
Which clause is used in PostgreSQL to filter grouped records that do not meet a certain condition?0
How to create a recursive query in PostgreSQL?