pgr_getColumnName - Deprecated Function¶
Warning
This function is deprecated!!!
- Is no longer supported.
- May be removed from future versions.
- There is no replacement.
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 retrieved. |
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 - Deprecated Function to check only for the existence of the column.
- pgr_getTableName - Deprecated Function to retrieve the name of the table as is stored in the postgres administration tables.