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.
Warning
This function is deprecated in 2.1 Use _pgr_getTableName instead
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 to check only for the existance of the column.
- pgr_getTableName to retrieve the name of the table as is stored in the postgres administration tables.