I have a table which I will populate every day from scratch (data coming
from a Foxpro system) and I am wandering if I could do something like:
drop table <name>
\i <create table script>
copy from <ascii file>
Can this be done? In particular will the drop table honor begin/end?
My alternative is to use delete from <table>. Besides been slower I wonder
if this would not make my "vacuum analyze" run much slower.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2001-11-18 05:37:34|
|Subject: Re: Drop table vs begin/end transaction |
|Previous:||From: Tom Lane||Date: 2001-11-16 19:35:22|
|Subject: Re: switching from mysql |