pgRouting Manual (2.0.0)

pgr_getColumnName

«  Developers’s Functions   ::   Contents   ::   pgr_getTableName  »

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

«  Developers’s Functions   ::   Contents   ::   pgr_getTableName  »