On Friday 10 June 2005 10:54 am, Kaare Rasmussen wrote:
> > actually I think part of the point of this was to give a command
> > line version of the reindex command, like we have for vaccum. If
> > that still matters, then it should probably stay. Actually it
> > should probably be converted to C and moved to /src/bin.
>
> Wouldn't something like
>
> echo 'REINDEX DATABASE {database};' | psql {database}
>
> be easier?
But not as easy as:
psql -c "reindex database {database}" {database}
Add connection options as desired.
Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
