Re: Feature request: Truncate table - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: Feature request: Truncate table
Date
Msg-id 1023910550.366.21.camel@lerlaptop
Whole thread Raw
In response to Feature request: Truncate table  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
On Wed, 2002-06-12 at 14:32, Dann Corbit wrote:
> Deletion of data from a PostgreSQL table is very slow.
> 
> It would be nice to have a very fast delete like "truncate table."
> 
> Now, truncate is a very dangerous command because it is not logged (but
> the same is true for other operations like bulk copy and select into).
> So one needs to be careful how this command is granted.  The same damage
> (accidental deletion of all data) can be done by drop table just as
> easily.
> 
> I frequently have to do this right now in PostgreSQL, but I simply
> emulate it by drop table/create table.
It's there:
$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

ler=# select version();                              version                               
---------------------------------------------------------------------PostgreSQL 7.2.1 on i386-portbld-freebsd4.6,
compiledby GCC 2.95.3
 
(1 row)

ler=# \h truncate
Command:     TRUNCATE
Description: empty a table
Syntax:
TRUNCATE [ TABLE ] name

ler=# 


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Feature request: Truncate table
Next
From: Billy O'Connor
Date:
Subject: Re: Feature request: Truncate table