Skip to content

Commit e7cad7b

Browse files
bmomjianbmomjian
committed
Add TRUNCATE command, with psql help and sgml additions.
1 parent abd4bf1 commit e7cad7b

File tree

15 files changed

+497
-44
lines changed

15 files changed

+497
-44
lines changed

‎doc/src/sgml/ref/truncate.sgml

Lines changed: 133 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,133 @@
1+
<!--
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.1 1999/09/23 17:02:28 momjian Exp $
3+
Postgres documentation
4+
-->
5+
6+
<refentry id="SQL-TRUNCATE">
7+
<refmeta>
8+
<refentrytitle id="SQL-TRUNCATE-TITLE">
9+
TRUNCATE
10+
</refentrytitle>
11+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
12+
</refmeta>
13+
<refnamediv>
14+
<refname>
15+
TRUNCATE
16+
</refname>
17+
<refpurpose>
18+
Close a cursor
19+
</refpurpose>
20+
</refnamediv>
21+
<refsynopsisdiv>
22+
<refsynopsisdivinfo>
23+
<date>1999-07-20</date>
24+
</refsynopsisdivinfo>
25+
<synopsis>
26+
TRUNCATE TABLE <replaceable class="PARAMETER">table</replaceable>
27+
</synopsis>
28+
29+
<refsect2 id="R2-SQL-TRUNCATE-1">
30+
<refsect2info>
31+
<date>1998-09-08</date>
32+
</refsect2info>
33+
<title>
34+
Inputs
35+
</title>
36+
<para>
37+
38+
<variablelist>
39+
<varlistentry>
40+
<term><replaceable class="PARAMETER">table</replaceable></term>
41+
<listitem>
42+
<para>
43+
The table name to truncate.
44+
</para>
45+
</listitem>
46+
</varlistentry>
47+
</variablelist>
48+
</para>
49+
</refsect2>
50+
51+
<refsect2 id="R2-SQL-TRUNCATE-2">
52+
<refsect2info>
53+
<date>1998-09-08</date>
54+
</refsect2info>
55+
<title>
56+
Outputs
57+
</title>
58+
<para>
59+
60+
<variablelist>
61+
<varlistentry>
62+
<term><computeroutput>
63+
TRUNCATE
64+
</computeroutput></term>
65+
<listitem>
66+
<para>
67+
Message returned if the table is successfully truncated.
68+
</para>
69+
</listitem>
70+
</varlistentry>
71+
</variablelist>
72+
</para>
73+
</refsect2>
74+
</refsynopsisdiv>
75+
76+
<refsect1 id="R1-SQL-TRUNCATE-1">
77+
<refsect1info>
78+
<date>1998-09-08</date>
79+
</refsect1info>
80+
<title>
81+
Description
82+
</title>
83+
<para>
84+
<command>TRUNCATE</command> quickly removes all rows from a table.
85+
</para>
86+
87+
<refsect1 id="R1-SQL-TRUNCATE-2">
88+
<title>
89+
Usage
90+
</title>
91+
<para>
92+
Truncate the table bigtable.
93+
</para>
94+
<programlisting>
95+
TRUNCATE TABLE bigtable;
96+
</programlisting>
97+
</refsect1>
98+
99+
<refsect1 id="R1-SQL-TRUNCATE-3">
100+
<title>
101+
Compatibility
102+
</title>
103+
104+
<refsect2 id="R2-SQL-TRUNCATE-4">
105+
<refsect2info>
106+
<date>1998-09-08</date>
107+
</refsect2info>
108+
<title>
109+
SQL92
110+
</title>
111+
<para>
112+
There is no <command>TRUNCATE</command> in <acronym>SQL92</acronym>.
113+
</para>
114+
</refsect2>
115+
</refsect1>
116+
</refentry>
117+
118+
<!-- Keep this comment at the end of the file
119+
Local variables:
120+
mode: sgml
121+
sgml-omittag:t
122+
sgml-shorttag:t
123+
sgml-minimize-attributes:nil
124+
sgml-always-quote-attributes:t
125+
sgml-indent-step:1
126+
sgml-indent-data:t
127+
sgml-parent-document:nil
128+
sgml-default-dtd-file:"../reference.ced"
129+
sgml-exposed-tags:nil
130+
sgml-local-catalogs:"/usr/lib/sgml/catalog"
131+
sgml-local-ecat-files:nil
132+
End:
133+
-->

0 commit comments

Comments
 (0)