BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

639INSERT single rows
640INSERT column lists
641DEFAULT values in INSERT
642INSERT multiple VALUES rows
643INSERT ... SELECT
644INSERT ... DEFAULT VALUES
645OVERRIDING SYSTEM VALUE
646OVERRIDING USER VALUE
647INSERT with generated columns
648INSERT RETURNING
649INSERT into views
650INSERT type coercion rules
651INSERT failures and constraint violations
652Bulk INSERT batching
653Multirow insert parameter limits
654Copying a table with CREATE TABLE AS
655SELECT INTO new tables
656Inserting parent and child rows with CTE returning values
657UPDATE basic assignment
658UPDATE with WHERE
659UPDATE multiple columns
660UPDATE row-valued assignment
661UPDATE from joined tables
662UPDATE self-referencing expressions
663UPDATE RETURNING old and new values
664UPDATE ONLY inheritance
665UPDATE with CASE expressions
666Update lost update hazards
667DELETE with WHERE
668DELETE USING joined tables
669DELETE RETURNING
670DELETE ONLY inheritance
671TRUNCATE table
672TRUNCATE RESTART IDENTITY
673TRUNCATE CASCADE
674DELETE versus TRUNCATE
675Soft deletes with deleted_at
676Safe destructive changes with transactions
677Previewing writes with SELECT first
678Archiving old rows before deletion
679Repairing duplicate rows with ctid
680Batching large deletes
681Batching large updates
682INSERT ON CONFLICT DO NOTHING
683ON CONFLICT DO UPDATE
684ON CONFLICT target columns
685ON CONFLICT ON CONSTRAINT
686The EXCLUDED pseudo-table
687Conditional upserts with WHERE
688Partial-index conflict targets
689Upsert counters
690Upsert and concurrent inserts
691Upsert idempotency keys
692MERGE statement structure
693MERGE WHEN MATCHED THEN UPDATE
694MERGE WHEN MATCHED THEN DELETE
695MERGE WHEN NOT MATCHED THEN INSERT
696MERGE WHEN NOT MATCHED BY SOURCE
697MERGE conditional actions
698MERGE RETURNING
699MERGE versus INSERT ON CONFLICT
700MERGE concurrency caveats
701Merging a nightly price feed
702Synchronizing inventory snapshots
703Slowly changing dimension type 1 upsert
704COPY FROM files
705COPY TO files
706COPY FROM STDIN
707COPY TO STDOUT
708CSV format options
709COPY HEADER option
710COPY DELIMITER and QUOTE options
711COPY NULL representation
712COPY FORCE_NOT_NULL and FORCE_NULL
713COPY binary format
714COPY ON_ERROR handling
715COPY FREEZE
716COPY and triggers
717COPY and constraint checks
718psql \copy
719Loading staging tables
720Deferring indexes during bulk loads
721Validating loaded rows
722Importing JSON lines
723Loading a taxi trip CSV dataset
724Exporting reports as CSV
725Foreign data wrappers for file_fdw

Databases & SQL

639INSERT single rows
640INSERT column lists
641DEFAULT values in INSERT
642INSERT multiple VALUES rows
643INSERT ... SELECT
644INSERT ... DEFAULT VALUES
645OVERRIDING SYSTEM VALUE
646OVERRIDING USER VALUE
647INSERT with generated columns
648INSERT RETURNING
649INSERT into views
650INSERT type coercion rules
651INSERT failures and constraint violations
652Bulk INSERT batching
653Multirow insert parameter limits
654Copying a table with CREATE TABLE AS
655SELECT INTO new tables
656Inserting parent and child rows with CTE returning values
657UPDATE basic assignment
658UPDATE with WHERE
659UPDATE multiple columns
660UPDATE row-valued assignment
661UPDATE from joined tables
662UPDATE self-referencing expressions
663UPDATE RETURNING old and new values
664UPDATE ONLY inheritance
665UPDATE with CASE expressions
666Update lost update hazards
667DELETE with WHERE
668DELETE USING joined tables
669DELETE RETURNING
670DELETE ONLY inheritance
671TRUNCATE table
672TRUNCATE RESTART IDENTITY
673TRUNCATE CASCADE
674DELETE versus TRUNCATE
675Soft deletes with deleted_at
676Safe destructive changes with transactions
677Previewing writes with SELECT first
678Archiving old rows before deletion
679Repairing duplicate rows with ctid
680Batching large deletes
681Batching large updates
682INSERT ON CONFLICT DO NOTHING
683ON CONFLICT DO UPDATE
684ON CONFLICT target columns
685ON CONFLICT ON CONSTRAINT
686The EXCLUDED pseudo-table
687Conditional upserts with WHERE
688Partial-index conflict targets
689Upsert counters
690Upsert and concurrent inserts
691Upsert idempotency keys
692MERGE statement structure
693MERGE WHEN MATCHED THEN UPDATE
694MERGE WHEN MATCHED THEN DELETE
695MERGE WHEN NOT MATCHED THEN INSERT
696MERGE WHEN NOT MATCHED BY SOURCE
697MERGE conditional actions
698MERGE RETURNING
699MERGE versus INSERT ON CONFLICT
700MERGE concurrency caveats
701Merging a nightly price feed
702Synchronizing inventory snapshots
703Slowly changing dimension type 1 upsert
704COPY FROM files
705COPY TO files
706COPY FROM STDIN
707COPY TO STDOUT
708CSV format options
709COPY HEADER option
710COPY DELIMITER and QUOTE options
711COPY NULL representation
712COPY FORCE_NOT_NULL and FORCE_NULL
713COPY binary format
714COPY ON_ERROR handling
715COPY FREEZE
716COPY and triggers
717COPY and constraint checks
718psql \copy
719Loading staging tables
720Deferring indexes during bulk loads
721Validating loaded rows
722Importing JSON lines
723Loading a taxi trip CSV dataset
724Exporting reports as CSV
725Foreign data wrappers for file_fdw

← Databases & SQL

Search the Databases & SQL glossary

Lesson 678 of 2,478·11. Data ModificationFree lesson

Archiving old rows before deletion

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy