Is there a shortcut for SELECT * FROM?

by

There is a shortcut for SELECT * FROM in standard SQL, so you can use it in psql:

TABLE tablename;

This syntax shorthand can only be used with a limited range of clauses. The manual:

It can be used as a top-level command or as a space-saving syntax
variant in parts of complex queries. Only the WITH, UNION, INTERSECT,
EXCEPT, ORDER BY, LIMIT, OFFSET, FETCH and FOR locking clauses can be
used with TABLE; the WHERE clause and any form of aggregation cannot
be used.

More Related Contents:

  1. Difference between LIKE and ~ in Postgres
  2. How do you use script variables in psql?
  3. PostgreSQL: encoding problems on Windows when using psql command line utility
  4. Select first row in each GROUP BY group?
  5. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  6. How to use RETURNING with ON CONFLICT in PostgreSQL?
  7. PostgreSQL DISTINCT ON with different ORDER BY
  8. IN vs ANY operator in PostgreSQL
  9. Query with LEFT JOIN not returning rows for count of 0
  10. How do I force Postgres to use a particular index?
  11. How to create a temporary function in PostgreSQL?
  12. Polymorphism in SQL database tables?
  13. Record returned from function has columns concatenated
  14. Query for element of array in JSON column
  15. INSERT rows into multiple tables in a single query, selecting from an involved table
  16. Casting NULL type when updating multiple rows
  17. How to round an average to 2 decimal places in PostgreSQL?
  18. Best way to delete millions of rows by ID
  19. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  20. How to find a table having a specific column in postgresql
  21. How to read the contents of an .sql file into an R script to run a query?
  22. PostgreSQL JOIN with array type with array elements order, how to implement?
  23. INSERT COMMAND :: ERROR: column “value” does not exist
  24. Return multiple columns and rows from a function PostgreSQL instead of record
  25. Check whether string is a date Postgresql
  26. SQL LIKE condition to check for integer?
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. SQL INNER JOIN syntax
  29. Postgresql query between date ranges
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment