On Sun, 18 Nov 2001, Tom Lane wrote:
> Francisco Reyes <lists(at)natserv(dot)com> writes:
> > My alternative is to use delete from <table>. Besides been slower I wonder
> > if this would not make my "vacuum analyze" run much slower.
> Consider TRUNCATE TABLE
Thanks for the info. Didn't know about truncate table
> so the drop/create/fill might be a better bet if you are worried
> about bad data during the fill.
I just had such a case. The table I was importing had a '\' and postgreSQL
didn't like it. I guess it must have some special meaning.
In response to
pgsql-novice by date
|Next:||From: Francisco Reyes||Date: 2001-11-18 21:12:50|
|Subject: When is it worth it to drop indexes on bulk loads?|
|Previous:||From: Tom Lane||Date: 2001-11-18 05:37:34|
|Subject: Re: Drop table vs begin/end transaction |