* SELECT in psql FROM shortcut**

In database queries, shortcuts can improve efficiency and simplify workflow. The psql console provides many useful shortcuts, where the SELECT * FROM table_name query is often used, especially during the learning process. To optimize this process, users may wonder if there is a cleaner alternative.

Reveal the shortcuts

The good news is that a shortcut to SELECT * FROM can be used in psql, called TABLE syntax. The format of this syntax is simple:

TABLE tablename;

Limitations and Usage

However, it should be noted that there are some limitations in TABLE syntax. It can only be used for specific clauses, namely WITH, UNION, INTERSECT, EXCEPT, ORDER BY, LIMIT, OFFSET, FETCH, and FOR locking. Aggregation and WHERE clauses are incompatible with this syntax.