pgr_getTableName¶
Nom¶
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: |
|
Histoire
- Nouveau depuis la version 2.0.0
Exemples¶
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 Données d’échantillon network.
Voir aussi¶
- Guide du développeur 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.