Say It In Postgres SQL-PostgreSQL Query Generation

Example

CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE, age INT);

Scenario

When a user needs to set up a new table for storing user data, including unique identifiers and specific data types for each column.

Example

INSERT INTO users (name, email, age) VALUES ('John Doe', '[email protected]', 25);

Scenario

To add new records into a database table, specifically for entering new user information into the users table.

Example

SELECT * FROM users WHERE age > 18 AND email LIKE '%example.com';

Scenario

For querying the database to retrieve records that meet certain conditions, such as selecting all adult users with an email address from a specific domain.

Example

UPDATE users SET email = '[email protected]' WHERE id = 1;

Scenario

Used to modify existing records in the database, such as changing a user's email address based on their unique identifier.

Example

DELETE FROM users WHERE age < 18;

Scenario

To remove records from a table that meet a specific condition, like deleting all users who are minors.