Viewing: riptutorial.com

[ Web Proxy ]

Viewing: https://riptutorial.com/postgresql/example/8466/basic-insert

postgresql Tutorial => Basic INSERT

[logo rip]

RIP Tutorial

Download postgresql (PDF)

Example

Let's say we have a simple table called person:

CREATE TABLE person (
    person_id BIGINT,
    name VARCHAR(255).
    age INT,
    city VARCHAR(255)
);

The most basic insert involves inserting all values in the table:

INSERT INTO person VALUES (1, 'john doe', 25, 'new york');

If you want to insert only specific columns, you need to explicitly indicate which columns:

INSERT INTO person (name, age) VALUES ('john doe', 25);

Note that if any constraints exist on the table , such as NOT NULL, you will be required to include those columns in either case.

Previous Next

[logo rip]

Get monthly updates about new articles, cheatsheets, and tricks.

Web Proxy Viewer | New URL | Original Page