pgr_getColumnName¶
Name¶
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.
History
- New in version 2.0.0
Examples¶
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)
The queries use the Sample Data network.
See Also¶
- Developer’s Guide 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.