SQL INSERT without specifying columns. What happens?

by

Your prof was right – you should name the columns explicitly before naming the values.

In this case though the values will be inserted in the order that they appear in the table definition.

The problem with this is that if that order changes, or columns are removed or added (even if they are nullable), then the insert will break.

In terms of its usefulness, not that much in production code. If you’re hand coding a quick insert then it might just help save you typing all the column names out.

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. PostgreSQL “Column does not exist” but it actually does
  3. Is SELECT or INSERT in a function prone to race conditions?
  4. Index for finding an element in a JSON array
  5. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  6. Is it possible to make a recursive SQL query?
  7. Way to try multiple SELECTs till a result is available?
  8. Column ‘mary’ does not exist
  9. Get top row(s) with highest value, with ties
  10. Double colon `::` notation in SQL
  11. Delete parent if it’s not referenced by any other child
  12. Window Functions: last_value(ORDER BY … ASC) same as last_value(ORDER BY … DESC)
  13. Query that ignore the spaces
  14. I keep getting the error “relation [TABLE] does not exist”
  15. Export specific rows from a PostgreSQL table as INSERT SQL script
  16. SQL query to get most recent row for each instance of a given key
  17. PostgreSQL Where count condition
  18. How to write a constraint concerning a max number of rows in postgresql?
  19. Postgres constraint for unique datetime range
  20. Postgres function returning table not returning data in columns
  21. SQL Transpose Rows as Columns
  22. PostgreSQL create table if not exists
  23. Get values from first and last row per group
  24. How can I add a column that doesn’t allow nulls in a Postgresql database?
  25. Create PostgreSQL ROLE (user) if it doesn’t exist
  26. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  27. PostgreSQL: Full Text Search – How to search partial words?
  28. Temporal database design, with a twist (live vs draft rows)
  29. How to bulk insert only new rows in PostreSQL
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment