Provided by: postgresql-client-8.0_8.0.7-2build1_i386 bug

NAME
       ALTER TABLESPACE - change the definition of a tablespace


SYNOPSIS
       ALTER TABLESPACE name RENAME TO newname
       ALTER TABLESPACE name OWNER TO newowner


DESCRIPTION
       ALTER TABLESPACE changes the definition of a tablespace.


PARAMETERS
       name   The name of an existing tablespace.

       newname
              The  new  name of the tablespace. The new name cannot begin with
              pg_, as such names are reserved for system tablespaces.

       newowner
              The new owner of the tablespace.  You must  be  a  superuser  to
              change the owner of a tablespace.


EXAMPLES
       Rename tablespace index_space to fast_raid:

       ALTER TABLESPACE index_space RENAME TO fast_raid;

       Change the owner of tablespace index_space:

       ALTER TABLESPACE index_space OWNER TO mary;


COMPATIBILITY
       There is no ALTER TABLESPACE statement in the SQL standard.


SEE ALSO
       CREATE     TABLESPACE     [create_tablespace(7)],    DROP    TABLESPACE
       [drop_tablespace(l)]