View source for SQL injection/Target Environments/Mapping/PostgreSQL

<noinclude>:<font size="-2">[[SQL injection]] > [[SQL injection/Target Environments|Target Environments]] > [[SQL injection/Target Environments/Mapping|Mapping]] > PostgreSQL</font></noinclude>

'''PostgreSQL''' has the '''current_database()''' function in stead of the '''database()''' function.

* <i>'''\dn''' equivalent:</i>

{{code|text=<source lang="sql">select schema_name from information_schema.schemata where catalog_name=[database name]</source>}}

* <i>'''\dt''' equivalent:</i>

{{code|text=<source lang="sql">select table_name from information_schema.tables table_type='BASE TABLE' AND table_schema=([schema_query]) and catalog_name=[database name]</source>}}

* <i>'''\d [column_name]''' equivalent</i>:

{{code|text=<source lang="sql">select column_name from information_schema.columns where table_name=([table_query]) and table_schema=([schema_query]) and catalog_name=[database_name]</source>}}


<noinclude>{{path2|PostgreSQL Mapping|SQL injection/Target Environments/Mapping/MySQL|SQL injection/Target Environments/Mapping/MS SQL|MySQL Mapping|MS SQL Mapping}}</noinclude>