pgRouting Manual (2.3)

pgr_getColumnName - Deprecated Function

«  pgr_drivingDistance - Deprecated Signature   ::   Contents   ::   pgr_getTableName - Deprecated Function  »

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

«  pgr_drivingDistance - Deprecated Signature   ::   Contents   ::   pgr_getTableName - Deprecated Function  »