{"Entry":{"collection":"psql","key":"cmd-6c-6f-5f-65-78-70-6f-72-74","name":"\\lo_export","aliases":["\\lo_export"],"metadata":{"aliases":["\\lo_export"],"category":"Data transfer and large objects","content_hash":"61052022ada4493642cd069a0af901199ba0a2da9dae8f2b6e4e6ddeb08e57ec","derived_content_hash":"5d251b942236eee033382159c502af6a9ce92024c9905b2dc52a24f42e244f50","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.099385+08:00","name":"\\lo_export","name_zh":"","slug":"cmd-6c-6f-5f-65-78-70-6f-72-74","summary":"Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system."}},"Definition":{"Collection":"psql","Key":"cmd-6c-6f-5f-65-78-70-6f-72-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-6c-6f-5f-65-78-70-6f-72-74","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\lo_export","comparison_data":{"definition":"Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system. Tip Use \\lo_list to find out the large object's OID .","modifiers":[],"signature":"\\lo_export loid filename","spellings":["\\lo_export"]},"comparison_hash":"7eb0e773a570c5f093a6b3f3d0cd2f095e978b96f1071d8b49412e804cf30eca","description":["Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system."],"description_zh":"从数据库中读取具有 OID loid 的大对象，并将其写入 filename 。请注意，这与服务器函数 lo_export 略有不同，后者使用运行数据库服务器的用户的权限，并在服务器的文件系统上操作。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        从数据库中读取具有 \u003cacronym class=\"acronym\"\u003eOID\u003c/acronym\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e 的大对象，并将其写入 \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e。请注意，这与服务器函数\n        \u003ccode class=\"function\"\u003elo_export\u003c/code\u003e 略有不同，后者使用运行数据库服务器的用户的权限，并在服务器的文件系统上操作。\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003e提示\u003c/h3\u003e\u003cp\u003e\n        使用\u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e 命令来查找大对象的 \u003cacronym class=\"acronym\"\u003eOID\u003c/acronym\u003e。\n        \u003c/p\u003e\u003c/div\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_export"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\lo_export"}],"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-EXPORT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\lo_export \u003cem class=\"replaceable\"\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Reads the large object with OID \u003cem class=\"replaceable\"\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e from the database and\n        writes it to \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e. Note that this is\n        subtly different from the server function\n        \u003ccode class=\"function\"\u003elo_export\u003c/code\u003e, which acts with the permissions\n        of the user that the database server runs as and on the server's\n        file system.\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\u003cp\u003e\n        Use \u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e to find out the large object's\n        OID.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LO-EXPORT","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_export loid filename","sources":[{"anchor":"APP-PSQL-META-COMMAND-LO-EXPORT","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-EXPORT"}],"spellings":["\\lo_export"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\lo_export","url":"/wiki/psql/cmd-6c-6f-5f-65-78-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_export","url":"/wiki/psql/cmd-6c-6f-5f-65-78-70-6f-72-74/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LO-EXPORT","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-EXPORT","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-EXPORT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-6c-6f-5f-65-78-70-6f-72-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\lo_export","Summary":"Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LO-EXPORT\"\u003e\u003cspan\u003e\u003ccode\u003e\\lo_export \u003cem\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Reads the large object with OID \u003cem\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e from the database and\n        writes it to \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e. Note that this is\n        subtly different from the server function\n        \u003ccode\u003elo_export\u003c/code\u003e, which acts with the permissions\n        of the user that the database server runs as and on the server\u0026#39;s\n        file system.\n        \u003c/p\u003e\u003cdiv\u003e\u003ch3\u003eTip\u003c/h3\u003e\u003cp\u003e\n        Use \u003ccode\u003e\\lo_list\u003c/code\u003e to find out the large object\u0026#39;s\n        OID.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"0f3a96fbbb80579eb2748438a19631691e053f124dbe5cef28de451a2f27c75e","Payload":{"description":["Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LO-EXPORT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\lo_export \u003cem class=\"replaceable\"\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Reads the large object with OID \u003cem class=\"replaceable\"\u003e\u003ccode\u003eloid\u003c/code\u003e\u003c/em\u003e from the database and\n        writes it to \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e. Note that this is\n        subtly different from the server function\n        \u003ccode class=\"function\"\u003elo_export\u003c/code\u003e, which acts with the permissions\n        of the user that the database server runs as and on the server's\n        file system.\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\u003cp\u003e\n        Use \u003ccode class=\"command\"\u003e\\lo_list\u003c/code\u003e to find out the large object's\n        OID.\n        \u003c/p\u003e\u003c/div\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_export","url":"/wiki/psql/cmd-6c-6f-5f-65-78-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_export","Signature":"\\lo_export loid filename","Modifiers":[]}],"SQLState":null,"Evidence":null}