pgRouting Manual (2.0.0)

pgr_getTableName

«  pgr_getColumnName   ::   Contents   ::   pgr_isColumnIndexed  »

pgr_getTableName

Name

pgr_getTableName — 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 record containing the registered names of the table and of the schema it belongs to.

(text sname, text tname)  pgr_getTableName(text tab)

Description

Parameters

tab:text table name with or without schema component.

Returns

sname:
  • text containing the registered name of the schema of table “tab”.
    • when the schema was not provided in “tab” the current schema is used.
  • NULL when :
    • The schema is not found in the postgres administration tables.
tname:
  • text containing the registered name of the table “tab”.
  • NULL when :
    • The schema is not found in the postgres administration tables.
    • The table “tab” is not registered under the schema sname in the postgres administration tables

History

  • New in version 2.0.0

Examples

SELECT * from pgr_getTableName('edge_table');

 sname  |   tname
--------+------------
 public | edge_table
(1 row)

SELECT * from pgr_getTableName('EdgeTable');

 sname  |   tname
--------+------------
 public |
(1 row)

SELECT * from pgr_getTableName('data.Edge_Table');
 sname | tname
-------+-------
       |
(1 row)

The examples use the Sample Data network.

See Also

«  pgr_getColumnName   ::   Contents   ::   pgr_isColumnIndexed  »