nepsilon/postgres-table-instead-of-select-from.md

Last active February 19, 2017 13:53

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nepsilon/74217f1efa40e8a3c9594e5d01484403.js"></script>
Save nepsilon/74217f1efa40e8a3c9594e5d01484403 to your computer and use it in GitHub Desktop.

PostgreSQL: TABLE instead of SELECT * FROM — First published in fullweb.io issue #59

Raw

PostgreSQL: TABLE instead of SELECT * FROM

Or how to save 7 keystrokes 🙌.

You can type TABLE foo instead of SELECT * FROM foo. The output will be the same:

foo-db=# TABLE foo;
 id    │  name  |  email
───────┼────────┼─────────
 70263 │ bar    | f@b.com
(1 row)