Re: reindex database

Στις Τετάρτη 14 Μάρτιος 2007 14:44, ο/η Sabin Coanda έγραψε:
> Hi,
>
> It would be so nice to use REINDEX DATABASE command without name, for the
> current database.
> Now the command is useless when a database schema script refers just
> itself, and the database name is not establish. I have to use REINDEX TABLE
> name instead searching all the database tables.
>
> What is your opinion ?

<path to your db sources>/contrib/reindexdb/reindexdb -a
reindexes everything.

Also your script would do a

#!/bin/csh
set mydb=`psql -q -t -c "SELECT current_database()" | tr -d " \n"`
<path to your db sources>/contrib/reindexdb/reindexdb -d $mydb

>
> Regards,
> Sabin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--
Achilleas Mantzios