Database Reference
In-Depth Information
You'll get a lot of benefit from tab completion, which will fill in the next part of syntax just by
pressing the
Tab
key. This also works for object names, so you can type in just the first few
letters, and then press
Tab
; all of the options will be displayed, so you can type in just enough
letters to make the object name unique and then hit
Tab
to get the rest.
One-line comments are double-dash as follows:
-- This is a single-line comment
And multiline comments are like C and Java:
/*
* Multi-line comment
*/
You'll probably agree that psql looks a little daunting at first, with strange backslash
commands. I do hope you'll take a few moments to understand the interface, and to keep
digging for more. psql is one of the most surprising parts of PostgreSQL, and the tool is
incredibly useful for database administration tasks when used alongside other tools.
There's more...
psql works across releases, though you may see a message like the following if you do so:
psql on Windows can be a little problematic. I'd recommend you use a terminal emulator
to connect to your server, and access psql from there.
See also
Check out some other useful features of psql, which are as follows:
F
Information functions
F
Output formatting
