pgr_getTableName - Deprecated Function¶
Warning
This function is deprecated!!!
- Is no longer supported.
- May be removed from future versions.
- There is no replacement.
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: |
|
|---|---|
| tname: |
|
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¶
- 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.