Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- PostgreSQL basics -- Connect: psql -U postgres -- Create database CREATE DATABASE myapp; \c myapp -- connect to database -- Create table with PostgreSQL-specific features CREATE TABLE users ( id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(255) UNIQUE NOT NULL, age INTEGER CHECK (age >= 0 AND age <= 150), tags TEXT[], -- arrays! metadata JSONB, -- JSON! created_at TIMESTAMPTZ DEFAULT NOW(), updated_at TIMESTAMPTZ DEFAULT NOW() ); -- Insert with RETURNING INSERT INTO users (name, email, tags) VALUES ('Alice', 'alice@example.com', ARRAY['admin', 'user']) RETURNING id, name, created_at; -- Query JSON data SELECT name, metadata->>'city' AS city FROM users WHERE metadata @> '{"country": "USA"}'::jsonb;
Result
Open