On Wednesday 26 September 2007 20:24:12 Tom Lane wrote: > "Matthew Dennis" <mdennis@xxxxxxxxxx> writes: > > Maybe I'm just missing something but I can't seem to get pg_dump to > > output copy statements. Regardless of the -d / --inserts flag it always > > outputs insert statements. > > I'm betting this is the same type of pilot error discussed earlier > today: > http://archives.postgresql.org/pgsql-general/2007-09/msg01230.php > In my world two identical pilot errors within a short timeframe are indicative of a bad interface. And yes, I've done this to (specified -d on a pg_dump command line, that is). jan -- -------------------------------------------------------------- Jan de Visser jdevisser@xxxxxxxxxxxxxxxxxx Baruk Khazad! Khazad ai-menu! -------------------------------------------------------------- ---------------------------(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