Examples 798–814 · Part IX: Data Engineering
| # | Example | Level |
|---|---|---|
| 798 | COPY from a file | Beginner |
| 799 | COPY options and formats | Intermediate |
| 800 | Load into a staging table first | Intermediate |
| 801 | Quarantine rejected rows | Intermediate |
| 802 | Make a load idempotent | Intermediate |
| 803 | Load in batches | Intermediate |
| 804 | Disable indexes and constraints for a bulk load | Intermediate |
| 805 | Load from another database with postgres_fdw | Intermediate |
| 806 | Read a file directly with file_fdw | Intermediate |
| 807 | Load JSON documents | Intermediate |
| 808 | Character encoding and malformed input | Intermediate |
| 809 | Parallel loading | Intermediate |
| 810 | Track what has been loaded | Intermediate |
| 811 | Late-arriving and out-of-order data | Intermediate |
| 812 | Validate before publishing | Intermediate |
| 813 | Measure load performance | Advanced |
| 814 | Design a loading pipeline | Advanced |
The solutions and explanations are in the book.