RewriteEngine on

RewriteRule ^(.*)/$ $1 [discardpath,noescape,qsappend]

RewriteRule ^\[(.*)\](?:/(.*))?$ $2 [discardpath,noescape,qsappend,env=base_url:http://$1]

# extract path components 1st->last

RewriteRule ^([^/]+)(?:/(.*))?$        $2?server=$1                         [discardpath,noescape,qsappend,env=page:all_db]

RewriteRule ^([^/]+)(?:/(.*))?$        $2?database=$1                       [discardpath,noescape,qsappend,env=page:schemas]

RewriteRule ^([^/]+)(?:/(.*))?$        $2?schema=$1                         [discardpath,noescape,qsappend,env=page:tables]

RewriteRule ^(views|functions)()$      $2                                   [discardpath,noescape,qsappend,env=page:$1]

RewriteRule ^view=([^/]+)(?:/(.*))?$   $2?view=$1&action=definition         [discardpath,noescape,qsappend,skip=2,env=page:viewproperties]

RewriteRule ^fn.oid=([^/]+)(?:/(.*))?$ $2?function_oid=$1&action=properties [discardpath,noescape,qsappend,skip=1,env=page:functions]

RewriteRule ^([^/]+)(?:/(.*))?$        $2?table=$1                          [discardpath,noescape,qsappend,env=page:tblproperties]

RewriteRule ^([^/]+)(?:/(.*))?$        $2?column=$1                         [discardpath,noescape,qsappend,env=page:colproperties]

# redirect to now-constructed URL

RewriteCond %{ENV:base_url} !=""

RewriteRule ^$ %{ENV:base_url}/%{ENV:page}.php [discardpath,last,noescape,qsappend,redirect]

## for internal URLs

RewriteCond %{ENV:innermost_dir} =phpPgAdmin