Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       REINDEX -

SYNOPSIS

       REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]

DESCRIPTION

       REINDEX   REINDEX

       o
           REINDEX

       o   PostgreSQL  B-REINDEX  Section 21.2 ``Routine Indexing''

PARAMETERS

       DATABASE

       TABLE
               "TOAST"

       INDEX

       name
               //

       FORCE

NOTES

          REINDEX INDEX  REINDEX TABLE  REINDEX  CREATE INDEX

            -P

          postmaster   -P   PostgreSQL   REINDEX DATABASEREINDEX TABLE REINDEX
       INDEX  REINDEX DATABASE   postgres(1)

         -P   libpq   PGOPTIONS  -P

        (pg_database pg_group pg_shadow REINDEX

        REINDEX  REINDEX   "index is not a btree/ btree "

         PostgreSQL 7.4 REINDEX TABLE  TOAST

EXAMPLES

         mytable

       REINDEX TABLE my_table;

       REINDEX INDEX my_index;

       $export PGOPTIONS="-P"
       $psql broken_db
       broken_db=> REINDEX DATABASE broken_db;
       broken_db=> \q

COMPATIBILITY

        SQL  REINDEX

       Postgresql  <laser@pgsqldb.org>