⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 libpgtcl.sgml

📁 关系型数据库 Postgresql 6.5.2
💻 SGML
📖 第 1 页 / 共 3 页
字号:
<!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOREAD"><REFMETA><REFENTRYTITLE>pg_lo_read</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_read</REFNAME><REFPURPOSE>read a large object</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOREAD-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>reading</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOREAD-2"><PRIMARY>pg_lo_read</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_read <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">bufVar</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOREAD-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE></TERM><LISTITEM><PARA>File descriptor for the large object from pg_lo_open.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">bufVar</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid buffer variable to contain the large object segment.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE></TERM><LISTITEM><PARA>Specifies the maximum allowable size of the large object segment.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOREAD-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>None</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOREAD-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_read</FUNCTION> reads at most <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE> bytes from a large object into a variable named <REPLACEABLE CLASS="PARAMETER">bufVar</REPLACEABLE>.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOREAD-2"><TITLE>Usage</TITLE><PARA><REPLACEABLE CLASS="PARAMETER">bufVar</REPLACEABLE> must be a valid variable name.</PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOWRITE"><REFMETA><REFENTRYTITLE>pg_lo_write</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_write</REFNAME><REFPURPOSE>write a large object</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOWRITE-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>writing</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOWRITE-2"><PRIMARY>pg_lo_write</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_write <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">buf</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOWRITE-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE></TERM><LISTITEM><PARA>File descriptor for the large object from pg_lo_open.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">buf</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid string variable to write to the large object.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE></TERM><LISTITEM><PARA>Specifies the maximum size of the string to write.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOWRITE-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>None</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOWRITE-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_write</FUNCTION> writes at most <REPLACEABLE CLASS="PARAMETER">len</REPLACEABLE> bytes to a large object from a variable <REPLACEABLE CLASS="PARAMETER">buf</REPLACEABLE>.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOWRITE-2"><TITLE>Usage</TITLE><PARA><REPLACEABLE CLASS="PARAMETER">buf</REPLACEABLE> must be the actual string to write, not a variable name.</PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOLSEEK"><REFMETA><REFENTRYTITLE>pg_lo_lseek</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_lseek</REFNAME><REFPURPOSE>seek to a position in a large object</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOLSEEK-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>positioning</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOLSEEK-2"><PRIMARY>pg_lo_lseek</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_lseek <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">offset</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">whence</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOLSEEK-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE></TERM><LISTITEM><PARA>File descriptor for the large object from pg_lo_open.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">offset</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a zero-based offset in bytes.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">whence</REPLACEABLE></TERM><LISTITEM><PARA> whence can be "SEEK_CUR", "SEEK_END", or "SEEK_SET" </PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOLSEEK-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>None</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOLSEEK-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_lseek</FUNCTION> positions to <REPLACEABLE CLASS="PARAMETER">offset</REPLACEABLE> bytes from the beginning of the large object.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOLSEEK-2"><TITLE>Usage</TITLE><PARA><REPLACEABLE CLASS="PARAMETER">whence</REPLACEABLE> can be "SEEK_CUR", "SEEK_END", or "SEEK_SET".</PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOTELL"><REFMETA><REFENTRYTITLE>pg_lo_tell</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_tell</REFNAME><REFPURPOSE>return the current seek position of a large object</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOTELL-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>positioning</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOTELL-2"><PRIMARY>pg_lo_tell</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_tell <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOTELL-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">fd</REPLACEABLE></TERM><LISTITEM><PARA>File descriptor for the large object from pg_lo_open.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOTELL-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">offset</REPLACEABLE></TERM><LISTITEM><PARA>A zero-based offset in bytes suitable for input to <Function>pg_lo_lseek</Function>.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOTELL-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_tell</FUNCTION> returns the currentto <REPLACEABLE CLASS="PARAMETER">offset</REPLACEABLE> in bytes from the beginning of the large object.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOTELL-2"><TITLE>Usage</TITLE><PARA></PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOUNLINK"><REFMETA><REFENTRYTITLE>pg_lo_unlink</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_unlink</REFNAME><REFPURPOSE>delete a large object</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOUNLINK-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>delete</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOUNLINK-2"><PRIMARY>pg_lo_unlink</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_unlink <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">lobjId</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOUNLINK-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">lobjId</REPLACEABLE></TERM><LISTITEM><PARA>Identifier for a large object.XXX Is this the same as objOid in other calls?? - thomas 1998-01-11</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOUNLINK-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>None</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOUNLINK-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_unlink</FUNCTION> deletes the specified large object.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOUNLINK-2"><TITLE>Usage</TITLE><PARA></PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOIMPORT"><REFMETA><REFENTRYTITLE>pg_lo_import</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_import</REFNAME><REFPURPOSE>import a large object from a Unix file</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOIMPORT-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>import</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOIMPORT-2"><PRIMARY>pg_lo_import</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_import <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOIMPORT-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE></TERM><LISTITEM><PARA>Unix file name.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOIMPORT-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>NoneXXX Does this return a lobjId? Is that the same as the objOid in other calls? thomas - 1998-01-11</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOIMPORT-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_import</FUNCTION> reads the specified file and places the contents into a large object.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOIMPORT-2"><TITLE>Usage</TITLE><PARA>  <Function>pg_lo_import</Function> must be called within a BEGIN/END transaction block.</PARA></REFSECT1></REFENTRY><!-- ********************************************************** --><REFENTRY ID="PGTCL-PGLOEXPORT"><REFMETA><REFENTRYTITLE>pg_lo_export</REFENTRYTITLE><REFMISCINFO>PGTCL - Large Objects</REFMISCINFO></REFMETA><REFNAMEDIV><REFNAME>pg_lo_export</REFNAME><REFPURPOSE>export a large object to a Unix file</REFPURPOSE><INDEXTERM ID="IX-PGTCL-PGLOEXPORT-1"><PRIMARY>pgtcl</PRIMARY><SECONDARY>export</SECONDARY></INDEXTERM><INDEXTERM ID="IX-PGTCL-PGLOEXPORT-2"><PRIMARY>pg_lo_export</PRIMARY></INDEXTERM></REFNAMEDIV><REFSYNOPSISDIV><REFSYNOPSISDIVINFO><DATE>1997-12-24</DATE></REFSYNOPSISDIVINFO><SYNOPSIS>pg_lo_export <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">lobjId</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE></SYNOPSIS><REFSECT2 ID="R2-PGTCL-PGLOEXPORT-1"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Inputs</TITLE><VARIABLELIST><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">conn</REPLACEABLE></TERM><LISTITEM><PARA>Specifies a valid database connection.</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">lobjId</REPLACEABLE></TERM><LISTITEM><PARA>Large object identifier.XXX Is this the same as the objOid in other calls?? thomas - 1998-01-11</PARA></LISTITEM></VARLISTENTRY><VARLISTENTRY><TERM>  <REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE></TERM><LISTITEM><PARA>Unix file name.</PARA></LISTITEM></VARLISTENTRY></VARIABLELIST></REFSECT2><REFSECT2 ID="R2-PGTCL-PGLOEXPORT-2"><REFSECT2INFO><DATE>1997-12-24</DATE></REFSECT2INFO><TITLE>Outputs</TITLE><PARA>NoneXXX Does this return a lobjId? Is that the same as the objOid in other calls? thomas - 1998-01-11</PARA></REFSECT2></REFSYNOPSISDIV><REFSECT1 ID="R1-PGTCL-PGLOEXPORT-1"><REFSECT1INFO><DATE>1997-12-24</DATE></REFSECT1INFO><TITLE>Description</TITLE><PARA><FUNCTION>pg_lo_export</FUNCTION> writes the specified large object into a Unix file.</PARA></REFSECT1><REFSECT1 ID="R1-PGTCL-PGLOEXPORT-2"><TITLE>Usage</TITLE><PARA>  <Function>pg_lo_export</Function> must be called within a BEGIN/END transaction block.</PARA></REFSECT1></REFENTRY></Sect1></Chapter>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -