Queries

Database ​

Table ​

Display mode ​

Use \x to toggle the way to display query results (table or expanded).

It is also possible to use \gx to apply expanded formatting mode for the current query only.

SELECT * FROM my_table \gx

Functions ​

SELECT COALESCE(title, 'NULL') AS title FROM posts;
SELECT LEFT(nick,10) FROM users;