{"Entry":{"collection":"psql","key":"cmd-69","name":"\\i","aliases":["\\i"],"metadata":{"aliases":["\\i"],"category":"Scripting and assistance","content_hash":"230d8c4c8e79b4fa06be5186287f94f92958f762275cc7101b066fa023ef3289","imported_at":"2026-09-30T00:40:45.062895+08:00","name":"\\i","name_zh":"","slug":"cmd-69","summary":"Reads input from the file filename and executes it as though it had been typed on the keyboard."}},"Definition":{"Collection":"psql","Key":"cmd-69","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-69","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\i","comparison_data":{"definition":"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 .","modifiers":[],"signature":"\\i or \\include filename","spellings":["\\i","\\include"]},"comparison_hash":"695dec210b67e0244446bfdc098b2b1581a39d38f97f8c4cb78ed6874ce1106f","description":["Reads input from the file filename and executes it as though it had been typed on the keyboard."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\i"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-INCLUDE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\i\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\include\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eReads input from the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e and executes it as though it had been typed on the keyboard.\u003c/p\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e is \u003ccode class=\"literal\"\u003e-\u003c/code\u003e (hyphen), then standard input is read until an EOF indication or \u003ccode class=\"command\"\u003e\\q\u003c/code\u003e 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.\u003c/p\u003e\n\u003cdiv class=\"note\"\u003e\n\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\n\u003cp\u003eIf you want to see the lines on the screen as they are read you must set the variable \u003ccode class=\"varname\"\u003eECHO\u003c/code\u003e to \u003ccode class=\"literal\"\u003eall\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-INCLUDE","modifiers":[],"related":[{"label":"\\include","url":"/wiki/psql/cmd-69-6e-63-6c-75-64-65/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\i or \\include filename","sources":[{"anchor":"APP-PSQL-META-COMMAND-INCLUDE","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-INCLUDE"}],"spellings":["\\i","\\include"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\i","url":"/wiki/psql/cmd-69/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\include","url":"/wiki/psql/cmd-69-6e-63-6c-75-64-65/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-INCLUDE","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-INCLUDE","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-INCLUDE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-69","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\i","Summary":"Reads input from the file filename and executes it as though it had been typed on the keyboard.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-INCLUDE\"\u003e\u003cspan\u003e\u003ccode\u003e\\i\u003c/code\u003e or \u003ccode\u003e\\include\u003c/code\u003e \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eReads input from the file \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e and executes it as though it had been typed on the keyboard.\u003c/p\u003e\n\u003cp\u003eIf \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e is \u003ccode\u003e-\u003c/code\u003e (hyphen), then standard input is read until an EOF indication or \u003ccode\u003e\\q\u003c/code\u003e 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.\u003c/p\u003e\n\u003cdiv\u003e\n\u003ch3\u003eNote\u003c/h3\u003e\n\u003cp\u003eIf you want to see the lines on the screen as they are read you must set the variable \u003ccode\u003eECHO\u003c/code\u003e to \u003ccode\u003eall\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"f70a13c2ddb8ebf02ac96ab3656e6d087d41d44ff84ecfe6daeec8afbe1faf1e","Payload":{"description":["Reads input from the file filename and executes it as though it had been typed on the keyboard."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-INCLUDE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\i\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\include\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eReads input from the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e and executes it as though it had been typed on the keyboard.\u003c/p\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e is \u003ccode class=\"literal\"\u003e-\u003c/code\u003e (hyphen), then standard input is read until an EOF indication or \u003ccode class=\"command\"\u003e\\q\u003c/code\u003e 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.\u003c/p\u003e\n\u003cdiv class=\"note\"\u003e\n\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\n\u003cp\u003eIf you want to see the lines on the screen as they are read you must set the variable \u003ccode class=\"varname\"\u003eECHO\u003c/code\u003e to \u003ccode class=\"literal\"\u003eall\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\include","url":"/wiki/psql/cmd-69-6e-63-6c-75-64-65/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\i","url":"/wiki/psql/cmd-69/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\include","url":"/wiki/psql/cmd-69-6e-63-6c-75-64-65/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\i","Signature":"\\i or \\include filename","Modifiers":[]},{"Version":"18","Ordinal":1,"Command":"\\include","Signature":"\\i or \\include filename","Modifiers":[]}],"SQLState":null,"Evidence":null}