你即將離開本站

並前往https://gis.stackexchange.com/questions/148429/postgresql-insert-from-multiple-select

PostgreSQL: insert from multiple select? - GIS Stack Exchange

Use UNION or UNION ALL to build one result from your two selects: insert into table_1 (name, id) select name, id from table_2 limit 1 UNION ...

確定！ 回上一頁

查詢 「postgrest insert」的人也找了：

  1. PostgreSQL INSERT INTO SELECT
    2.
  2. PostgreSQL insert multiple rows
    3.
  3. PostgreSQL CREATE TABLE
    4.
  4. PostgreSQL INSERT list
    5.
  5. Postgresql insert query
    6.
  6. PostgreSQL ADD column
    7.
  7. PostgreSQL INSERT if not exists
    8.
  8. PostgreSQL UPDATE
    9.