SQL Query -> Insert Info In One Table

Job ID: 30783108

Budget: $10 – $30 CAD

I want to transfer all relevant information from:

Table1 - Quotes => Table2 - Notes.

How would I do this in PostgreSQL?

Table 1: Quotes - 1000 rows
Columns:
- quote_id
- quote_money
- comment
- created_by
- created_on

Table 2 - Notes
Columns
- note_id
- quote_id
- note_comment
- created_by
- created_on
Related categories: SQL MySQL Database Administration PostgreSQL