Wiki / psql Commands / Scripting and assistance

\include

Reads input from the file filename and executes it as though it had been typed on the keyboard.

Reading PostgreSQL 18.6.

Description

Reads input from the file filename and executes it as though it had been typed on the keyboard.

Client: psql 18.6
Case-sensitive spelling: \include

Usage

\i or \include filename

Spellings in this manual definition

Command	Documented suffix modifiers
\i	None listed in this signature
\include	None listed in this signature

Manual definition

\i or \include filename

Reads input from the file filename and executes it as though it had been typed on the keyboard.

If filename is - (hyphen), then standard input is read until an EOF indication or \q meta-command. This can be used to intersperse interactive input with input from files. Note that Readline behavior will be used only if it is active at the outermost level.

Note

If you want to see the lines on the screen as they are read you must set the variable ECHO to all.

Related entries

Documentation and source

18.6 English manual · app-psql.html

Source build

Version: 18.6
Build: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint: ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

Compare versions

PostgreSQL 17 → 18: unchanged.

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.