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:
begin transaction
drop table <name>
\i <create table script>
copy from <ascii file>
end transaction
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.