pgr_getColumnName¶
Nom¶
pgr_getColumnName — Retrieves the name of the column as is stored in the postgres administration tables.
Note
This function is intended for the developer’s aid.
Synopsis¶
Returns a text contining the registered name of the column.
text pgr_getColumnName(tab text, col text);
Description¶
Parameters
| tab: | text table name with or without schema component. |
|---|---|
| col: | text column name to be retrived. |
Returns
- text containing the registered name of the column.
- NULL when :
- The table “tab” is not found or
- Column “col” is not found in table “tab” in the postgres administration tables.
Histoire
- Nouveau depuis la version 2.0.0
Exemples¶
SELECT pgr_getColumnName('edge_table','the_geom');
pgr_iscolumnintable
---------------------
the_geom
(1 row)
SELECT pgr_getColumnName('edge_table','The_Geom');
pgr_iscolumnintable
---------------------
the_geom
(1 row)
Les requêtes utilisent le réseau Données d’échantillon.
Voir aussi¶
- Guide du développeur for the tree layout of the project.
- pgr_isColumnInTable to check only for the existance of the column.
- pgr_getTableName to retrieve the name of the table as is stored in the postgres administration tables.