Can I use return value of INSERT…RETURNING in another INSERT?

by

You can do so starting with Postgres 9.1:

with rows as (
INSERT INTO Table1 (name) VALUES ('a_title') RETURNING id
)
INSERT INTO Table2 (val)
SELECT id
FROM rows

In the meanwhile, if you’re only interested in the id, you can do so with a trigger:

create function t1_ins_into_t2()
  returns trigger
as $$
begin
  insert into table2 (val) values (new.id);
  return new;
end;
$$ language plpgsql;

create trigger t1_ins_into_t2
  after insert on table1
for each row
execute procedure t1_ins_into_t2();

More Related Contents:

  1. Postgres: INSERT if does not exist already
  2. Insert data in 3 tables at a time using Postgres
  3. How to exit from PostgreSQL command line utility: psql
  4. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  5. PostgreSQL error: Fatal: role “username” does not exist
  6. How to perform update operations on columns of type JSONB in Postgres 9.4
  7. How to convert primary key from integer to serial?
  8. See and clear Postgres caches/buffers?
  9. ClassNotFoundException with PostgreSQL and JDBC
  10. How to get function parameter lists (so I can drop a function)
  11. Find difference between timestamps in seconds in PostgreSQL
  12. Unable to connect PostgreSQL to remote database using pgAdmin
  13. How to convert a postgres database to sqlite
  14. How can I change a PostgreSQL user password?
  15. INSERT COMMAND :: ERROR: column “value” does not exist
  16. I forgot the password I entered during PostgreSQL installation
  17. Function to loop through and select data from multiple tables
  18. SQL query column does not exist error
  19. SQL Sub queries in check constraint
  20. Postgresql enforce unique two-way combination of columns
  21. Find Parent Recursively using Query
  22. Is there a way to disable updates/deletes but still allow triggers to perform them?
  23. Terminate hung query (idle in transaction)
  24. Reset PostgreSQL primary key to 1
  25. About clustered index in postgres
  26. Setting application_name on Postgres/SQLAlchemy
  27. How to fix pg_dump version mismatch errors?
  28. plpgsql error “RETURN NEXT cannot have a parameter in function with OUT parameters” in table-returning function
  29. How do I temporarily disable triggers in PostgreSQL?
  30. Are PostgreSQL functions transactional?

Leave a Comment