How to see the CREATE VIEW code for a view in PostgreSQL?

by

Kept having to return here to look up pg_get_viewdef (how to remember that!!), so searched for a more memorable command… and got it:

\d+ viewname

You can see similar sorts of commands by typing \? at the pgsql command line.

Bonus tip: The emacs command sql-postgres makes pgsql a lot more pleasant (edit, copy, paste, command history).

More Related Contents:

  1. Store common query as column?
  2. Why the “Group BY” by month didn’t work? [closed]
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. How to change PostgreSQL user password?
  7. How to get the count of current month Sunday’s in psql?
  8. Restore a postgres backup file using the command line?
  9. Running PostgreSQL in memory only
  10. How to close idle connections in PostgreSQL automatically?
  11. Refresh a materialized view automatically using a rule or notify
  12. postgresql – replace all instances of a string within text field
  13. Is it possible to have autoincrement number without it being an ID?
  14. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  15. How do I login and authenticate to Postgresql after a fresh install?
  16. Insert if not exists, else return id in postgresql
  17. function returns multiple columns as a single column instead of multiple columns
  18. Sequences not affected by transactions?
  19. Postgres: check if array field contains value?
  20. Dynamic pivot query using PostgreSQL 9.3
  21. PostgreSQL ERROR: canceling statement due to conflict with recovery
  22. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  23. eliminate duplicate array values in postgres
  24. Find Parent Recursively using Query
  25. Is there a way to disable updates/deletes but still allow triggers to perform them?
  26. Error: Column does not exist in postgresql for update [duplicate]
  27. Postgres table column name restrictions?
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment