Syntax

SHOW PERSONAL FILES
    [ LIKE '<pattern>' ]
    [ ORDER BY '<key>' [ ASC | DESC ],... ]
    [ LIMIT <limit> ] [ RECURSIVE ] [ EXTENDED ]

Arguments

• pattern: Specifies a pattern similar to the SQL LIKE clause and returns files with names that match the specified pattern. Uses % as the wildcard character.

• key: Key used to sort the result set.

• limit: An integer value.

Remarks

• The LIMIT clause limits the number of results to the specified number.

• By default, the result is sorted in the ascending order.

• Specify the RECURSIVE clause to list the files recursively.

• Specify the EXTENDED clause to return more information on the files.

Example

The following command lists the files in the personal space with additional information:

SHOW PERSONAL FILES EXTENDED;