{"Entry":{"collection":"psql","key":"cmd-6c-6f-5f-69-6d-70-6f-72-74","name":"\\lo_import","aliases":["\\lo_import"],"metadata":{"aliases":["\\lo_import"],"category":"Data transfer and large objects","content_hash":"62a2488c171032ea6e72704447a0e10db57aa5ce72cbb5eb05ab72a7e4431ece","derived_content_hash":"738f9811bf03307eab995dca6f4752a83c0228c38a975fa182a6e132fa417d73","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:45.103355+08:00","name":"\\lo_import","name_zh":"","slug":"cmd-6c-6f-5f-69-6d-70-6f-72-74","summary":"Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:"}},"Definition":{"Collection":"psql","Key":"cmd-6c-6f-5f-69-6d-70-6f-72-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-6c-6f-5f-69-6d-70-6f-72-74","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\lo_import","comparison_data":{"definition":"Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example: foo=\u003e \\lo_import '/home/peter/pictures/photo.xcf' 'a picture of me' lo_import 152801 The response indicates that the large object received object ID 152801, which can be used to access the newly-created large object in the future. For the sake of readability, it is recommended to always associate a human-readable comment with every object. Both OIDs and comments can be viewed with the \\lo_list command. Note that this command is subtly different from the server-side lo_import because it acts as the local user on the local file system, rather than the server's user and file system.","modifiers":[],"signature":"\\lo_import filename [ comment ]","spellings":["\\lo_import"]},"comparison_hash":"8f4de1ad11cc73ebf020f5c1b20258194df6c45e7cd64f1cf359888ecb510f3a","description":["Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:"],"description_zh":"将文件存储到一个 PostgreSQL 大对象中。可选地，它将给定的注释与对象关联起来。例如：","description_zh_html":"\u003cdd\u003e\u003cp\u003e将文件存储到一个 \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 大对象中。可选地，它将给定的注释与对象关联起来。例如：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003e\nfoo=\u0026gt; \u003cstrong class=\"userinput\"\u003e\u003ccode\u003e\\lo_import '/home/peter/pictures/photo.xcf' 'a picture of me'\u003c/code\u003e\u003c/strong\u003e\nlo_import 152801\n\u003c/pre\u003e\u003cp\u003e响应表明大对象获得了对象 ID 152801，这个 ID 可以用来在将来访问新创建的大对象。为便于阅读，建议始终为每个对象关联一条便于人阅读的注释。查看 OID 和注释时，可以使用\u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e 命令。\u003c/p\u003e\u003cp\u003e\n        请注意，此命令与服务器端的 \u003ccode class=\"function\"\u003elo_import\u003c/code\u003e 略有不同，因为它作为本地用户在本地文件系统上操作，而不是服务器的用户和文件系统。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\lo_import"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\lo_import"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LO-IMPORT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\lo_import \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecomment\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Stores the file into a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e\n        large object. Optionally, it associates the given\n        comment with the object. Example:\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003efoo=\u0026gt; \u003cstrong class=\"userinput\"\u003e\u003ccode\u003e\\lo_import '/home/peter/pictures/photo.xcf' 'a picture of me'\u003c/code\u003e\u003c/strong\u003e\nlo_import 152801\n\u003c/pre\u003e\u003cp\u003e\n        The response indicates that the large object received object\n        ID 152801, which can be used to access the newly-created large\n        object in the future. For the sake of readability, it is\n        recommended to always associate a human-readable comment with\n        every object. Both OIDs and comments can be viewed with the\n        \u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\n        Note that this command is subtly different from the server-side\n        \u003ccode class=\"function\"\u003elo_import\u003c/code\u003e because it acts as the local user\n        on the local file system, rather than the server's user and file\n        system.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LO-IMPORT","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\lo_import filename [ comment ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-LO-IMPORT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LO-IMPORT"}],"spellings":["\\lo_import"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\lo_import","url":"/wiki/psql/cmd-6c-6f-5f-69-6d-70-6f-72-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\lo_import","url":"/wiki/psql/cmd-6c-6f-5f-69-6d-70-6f-72-74/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LO-IMPORT","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-LO-IMPORT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LO-IMPORT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-6c-6f-5f-69-6d-70-6f-72-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\lo_import","Summary":"Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LO-IMPORT\"\u003e\u003cspan\u003e\u003ccode\u003e\\lo_import \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e [ \u003cem\u003e\u003ccode\u003ecomment\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Stores the file into a \u003cspan\u003ePostgreSQL\u003c/span\u003e\n        large object. Optionally, it associates the given\n        comment with the object. Example:\n\u003c/p\u003e\u003cpre\u003efoo=\u0026gt; \u003cstrong\u003e\u003ccode\u003e\\lo_import \u0026#39;/home/peter/pictures/photo.xcf\u0026#39; \u0026#39;a picture of me\u0026#39;\u003c/code\u003e\u003c/strong\u003e\nlo_import 152801\n\u003c/pre\u003e\u003cp\u003e\n        The response indicates that the large object received object\n        ID 152801, which can be used to access the newly-created large\n        object in the future. For the sake of readability, it is\n        recommended to always associate a human-readable comment with\n        every object. Both OIDs and comments can be viewed with the\n        \u003ccode\u003e\\lo_list\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\n        Note that this command is subtly different from the server-side\n        \u003ccode\u003elo_import\u003c/code\u003e because it acts as the local user\n        on the local file system, rather than the server\u0026#39;s user and file\n        system.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"fcc35c11c42a0fb2ce79ba845f796640500c6c624fdfb153b18ef5776798e02c","Payload":{"description":["Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:"],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LO-IMPORT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\lo_import \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecomment\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Stores the file into a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e\n        large object. Optionally, it associates the given\n        comment with the object. Example:\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003efoo=\u0026gt; \u003cstrong class=\"userinput\"\u003e\u003ccode\u003e\\lo_import '/home/peter/pictures/photo.xcf' 'a picture of me'\u003c/code\u003e\u003c/strong\u003e\nlo_import 152801\n\u003c/pre\u003e\u003cp\u003e\n        The response indicates that the large object received object\n        ID 152801, which can be used to access the newly-created large\n        object in the future. For the sake of readability, it is\n        recommended to always associate a human-readable comment with\n        every object. Both OIDs and comments can be viewed with the\n        \u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\n        Note that this command is subtly different from the server-side\n        \u003ccode class=\"function\"\u003elo_import\u003c/code\u003e because it acts as the local user\n        on the local file system, rather than the server's user and file\n        system.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"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":"\\lo_import","url":"/wiki/psql/cmd-6c-6f-5f-69-6d-70-6f-72-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\lo_import","Signature":"\\lo_import filename [ comment ]","Modifiers":[]}],"SQLState":null,"Evidence":null}