RewriteEngine on

RewriteOptions AllowNoSlash InheritBefore

SetEnvIf Request_URI ^ innermost_dir=phpPgAdmin

# remove trailing / (not used)

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

# extract base URL

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

# extract path components 1st->last

#

# phpPgAdmin bug causes page to be ignored when not logged in. this is partially

# fixed by also specifying subject, which is not ignored. (however, when it

# falls back to using subject, it will go to the last selected tab, not the

# default, leftmost tab.)

#

# subject values @ /usr/share/phppgadmin/classes/Misc.php#getSubjectParams()

RewriteRule ^                          -                                    [discardpath,noescape,qsappend,env=subject:root,env=page:servers]

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

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

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

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

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

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

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

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

# custom pages

# must be in query string b/c .php filename would be treated as path element

RewriteCond %{QUERY_STRING} ^(?:.*&)?page=([^&]*)

RewriteRule ^ - [discardpath,noescape,qsappend,env=!subject,env=page:%1]

# redirect to now-constructed URL

# only append subject if non-empty, to avoid confusing redirect.php

RewriteCond %{ENV:base_url} !=""

RewriteCond %{ENV:subject} ="" [ornext]

RewriteCond ?subject=%{ENV:subject} ^(.*)$

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

## for internal URLs

# auto-add trailing / (dir without trailing / is absolute filesystem path)

RewriteCond %{ENV:innermost_dir} =phpPgAdmin

RewriteRule ^/ %{REQUEST_URI}/ [discardpath,last,noescape,qsappend,redirect]