[EMAIL PROTECTED] ("[EMAIL PROTECTED]") writes: > I know in mysql, index will auto change after copying data Of > course, index will change after inserting a line in postgresql, but > what about copying data?
Do you mean, by this, something like... "Are indexes affected by loading data using the COPY command just as they are if data is loaded using INSERT?" If so, then the answer is "Yes, certainly." Indexes are updated whichever statement you use to load in data. -- let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;; http://www.ntlug.org/~cbbrowne/finances.html Rules of the Evil Overlord #160. "Before being accepted into my Legions of Terror, potential recruits will have to pass peripheral vision and hearing tests, and be able to recognize the sound of a pebble thrown to distract them." <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match