BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

51Installing PostgreSQL packages
52Running PostgreSQL in a container
53Initializing a cluster with initdb
54Starting and stopping PostgreSQL with pg_ctl
55Creating a development database with createdb
56PostgreSQL host, port, and database names
57Connection URIs and keyword connection strings
58Local Unix sockets versus TCP connections
59PGHOST, PGPORT, PGDATABASE, and PGUSER
60Password files with .pgpass
61Verifying connections with pg_isready
62Inspecting server versions
63Installing the Pagila sample database
64Loading a bookstore seed script
65Recreating a disposable practice database
66Keeping database credentials out of source control
67Connecting with psql
68psql backslash commands versus SQL
69Listing databases with \l
70Listing tables with \dt
71Describing relations with \d
72Listing schemas with \dn
73Listing functions with \df
74Inspecting users with \du
75Switching connections with \connect
76Executing script files with \i
77Editing queries with \e
78Expanded output with \x
79Changing output formats with \pset
80Redirecting output with \o
81Timing statements with \timing
82psql variables and interpolation
83Conditional scripting with \if
84Stopping scripts with ON_ERROR_STOP
85Transaction-wrapped scripts with psql --single-transaction
86Inspecting connection details with \conninfo
87Installing the sqlite3 command-line client
88Opening an SQLite database file
89SQLite in-memory databases
90SQLite dot commands
91Inspecting SQLite schemas with .schema
92Formatting SQLite results with .mode
93Importing CSV files with SQLite .import
94Creating SQLite backups with .backup
95Connecting pgAdmin to PostgreSQL
96Browsing tables in DBeaver
97SQL editor autocompletion and metadata refresh
98Reading query errors and SQLSTATE codes
99Separating development and production connections
100Managing client-side autocommit
101Inspecting a museum collection database
102Exporting a query result without changing data

Databases & SQL

51Installing PostgreSQL packages
52Running PostgreSQL in a container
53Initializing a cluster with initdb
54Starting and stopping PostgreSQL with pg_ctl
55Creating a development database with createdb
56PostgreSQL host, port, and database names
57Connection URIs and keyword connection strings
58Local Unix sockets versus TCP connections
59PGHOST, PGPORT, PGDATABASE, and PGUSER
60Password files with .pgpass
61Verifying connections with pg_isready
62Inspecting server versions
63Installing the Pagila sample database
64Loading a bookstore seed script
65Recreating a disposable practice database
66Keeping database credentials out of source control
67Connecting with psql
68psql backslash commands versus SQL
69Listing databases with \l
70Listing tables with \dt
71Describing relations with \d
72Listing schemas with \dn
73Listing functions with \df
74Inspecting users with \du
75Switching connections with \connect
76Executing script files with \i
77Editing queries with \e
78Expanded output with \x
79Changing output formats with \pset
80Redirecting output with \o
81Timing statements with \timing
82psql variables and interpolation
83Conditional scripting with \if
84Stopping scripts with ON_ERROR_STOP
85Transaction-wrapped scripts with psql --single-transaction
86Inspecting connection details with \conninfo
87Installing the sqlite3 command-line client
88Opening an SQLite database file
89SQLite in-memory databases
90SQLite dot commands
91Inspecting SQLite schemas with .schema
92Formatting SQLite results with .mode
93Importing CSV files with SQLite .import
94Creating SQLite backups with .backup
95Connecting pgAdmin to PostgreSQL
96Browsing tables in DBeaver
97SQL editor autocompletion and metadata refresh
98Reading query errors and SQLSTATE codes
99Separating development and production connections
100Managing client-side autocommit
101Inspecting a museum collection database
102Exporting a query result without changing data

← Databases & SQL

Search the Databases & SQL glossary

Lesson 90 of 2,478·2. Local Environments and SQL ClientsFree lesson

SQLite dot commands

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy