Queries

Database ​

CREATE DATABASE dbname;
DROP DATABASE dbname;

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;