Sql

Search

return insert results in POSTGRESQL

# to select specific columns
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING id, firstname;
# to return every column
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING *;

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to check current user in mysql
Sql :: install postgresql on raspberry pi
Sql :: mysql select where not in multiple tables
Sql :: create mysql user on all hosts
Sql :: ora-00054 find lock
Sql :: date 3 months from today sql
Sql :: oracle user privileges
Sql :: HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
Sql :: update query formula in excel
Sql :: sql delete multiple conditions
Sql :: insert multiple rows in sql workbench
Sql :: Object of class mysqli_result could not be converted to string
Sql :: phpmyadmin delete user
Sql :: where date major today mysql
Sql :: not operator in oracle
Sql :: join to find results not in another table
Sql :: date_trunc postgres
Sql :: sql syntax create timestamp column
Sql :: MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
Sql :: create database hive
Sql :: python how escape sql
Sql :: allsource oracle
Sql :: where date in datetime mysql
Sql :: mysql order
Sql :: sqlalchemy left join
Sql :: 2nd highest salary in mysql
Sql :: show slave status mysql
Sql :: MYSQL select last query
Sql :: mysql select multiple rows into one column
Sql :: add column if not exists mysql

Search

SQL

return insert results in POSTGRESQL

ADD CONTENT