File tree Expand file tree Collapse file tree 3 files changed +20
-13
lines changed Expand file tree Collapse file tree 3 files changed +20
-13
lines changed Original file line number Diff line number Diff line change 1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.11 1999/08/06 13:50:29 thomas Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.12 1999/10/01 15:24:09 thomas Exp $
3
3
Postgres documentation
4
4
Complete list of usable sgml source files in this directory.
5
5
-->
@@ -93,6 +93,7 @@ Complete list of usable sgml source files in this directory.
93
93
<!entity selectInto system "select_into.sgml">
94
94
<!entity set system "set.sgml">
95
95
<!entity show system "show.sgml">
96
+ <!entity truncate system "truncate.sgml">
96
97
<!entity unlisten system "unlisten.sgml">
97
98
<!entity update system "update.sgml">
98
99
<!entity vacuum system "vacuum.sgml">
Original file line number Diff line number Diff line change 1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.18 1999/08/06 13:50:30 thomas Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.19 1999/10/01 15:24:09 thomas Exp $
3
3
Postgres documentation
4
4
-->
5
5
@@ -67,6 +67,7 @@ Postgres documentation
67
67
&selectInto;
68
68
&set;
69
69
&show;
70
+ &truncate;
70
71
&unlisten;
71
72
&update;
72
73
&vacuum;
Original file line number Diff line number Diff line change 1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.1 1999/09/23 17:02:28 momjian Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.2 1999/10/01 15:24:09 thomas Exp $
3
3
Postgres documentation
4
4
-->
5
5
@@ -15,15 +15,15 @@ Postgres documentation
15
15
TRUNCATE
16
16
</refname>
17
17
<refpurpose>
18
- Close a cursor
18
+ Empty a table
19
19
</refpurpose>
20
20
</refnamediv>
21
21
<refsynopsisdiv>
22
22
<refsynopsisdivinfo>
23
23
<date>1999-07-20</date>
24
24
</refsynopsisdivinfo>
25
25
<synopsis>
26
- TRUNCATE TABLE <replaceable class="PARAMETER">table </replaceable>
26
+ TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name </replaceable>
27
27
</synopsis>
28
28
29
29
<refsect2 id="R2-SQL-TRUNCATE-1">
@@ -37,10 +37,10 @@ TRUNCATE TABLE <replaceable class="PARAMETER">table</replaceable>
37
37
38
38
<variablelist>
39
39
<varlistentry>
40
- <term><replaceable class="PARAMETER">table </replaceable></term>
40
+ <term><replaceable class="PARAMETER">name </replaceable></term>
41
41
<listitem>
42
42
<para>
43
- The table name to truncate .
43
+ The name of the table to be truncated .
44
44
</para>
45
45
</listitem>
46
46
</varlistentry>
@@ -81,19 +81,24 @@ TRUNCATE
81
81
Description
82
82
</title>
83
83
<para>
84
- <command>TRUNCATE</command> quickly removes all rows from a table.
84
+ <command>TRUNCATE</command> quickly removes all rows from a
85
+ table. It has the same effect as an unqualified
86
+ <command>DELETE</command> but since it does not actually scan the
87
+ table it is faster. This is most effective on large tables.
85
88
</para>
86
-
89
+ </refsect1>
90
+
87
91
<refsect1 id="R1-SQL-TRUNCATE-2">
88
92
<title>
89
93
Usage
90
94
</title>
91
95
<para>
92
- Truncate the table bigtable.
93
- </para>
94
- <programlisting>
96
+ Truncate the table <literal> bigtable</literal>:
97
+
98
+ <programlisting>
95
99
TRUNCATE TABLE bigtable;
96
- </programlisting>
100
+ </programlisting>
101
+ </para>
97
102
</refsect1>
98
103
99
104
<refsect1 id="R1-SQL-TRUNCATE-3">
You can’t perform that action at this time.
0 commit comments