Get the default values of table columns in Postgres?

by

Use the information schema:

SELECT column_name, column_default
FROM information_schema.columns
WHERE (table_schema, table_name) = ('public', 'mytable')
ORDER BY ordinal_position;

 column_name │             column_default             
─────────────┼────────────────────────────────────────
 integer     │ 2
 text        │ 'I am default'::character varying
 moretext    │ 'I am also default'::character varying
 unimportant │ 
(4 rows)

Up to the schema naming, this should work in any SQL database system.

More Related Contents:

  1. Select rows which are not present in other table
  2. Optimize GROUP BY query to retrieve latest row per user
  3. How to implement a many-to-many relationship in PostgreSQL?
  4. Aggregate columns with additional (distinct) filters
  5. Check if value exists in Postgres array
  6. Insert data in 3 tables at a time using Postgres
  7. How to use ANY instead of IN in a WHERE clause?
  8. Is there a shortcut for SELECT * FROM?
  9. sql statement error: “column .. does not exist”
  10. What is the difference between single quotes and double quotes in PostgreSQL?
  11. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  12. sql ORDER BY multiple values in specific order?
  13. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  14. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  15. Best way to count rows by arbitrary time intervals
  16. PostgreSQL sequence based on another column
  17. Sorting null values after all others, except special
  18. Reference alias in WHERE clause
  19. Fastest check if row exists in PostgreSQL
  20. PostgreSQL ORDER BY issue – natural sort
  21. Discard millisecond part from timestamp
  22. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  23. SQL column reference “id” is ambiguous
  24. How to use multiple CTEs in a single SQL query?
  25. IN Clause with NULL or IS NULL
  26. postgres – where in (list) – column does not exist
  27. incomplete information from query on pg_views [duplicate]
  28. How to get a list column names and datatypes of a table in PostgreSQL?
  29. How to detect query which holds the lock in Postgres?
  30. PostgreSQL: top n entries per item in same table

Leave a Comment