pgr_isColumnIndexed¶
Nom¶
pgr_isColumnIndexed — Vérifier si une colonne dans une table est indexée.
Note
This function is intended for the developer’s aid.
Synopsis¶
Returns true when the column “col” in table “tab” is indexed.
boolean pgr_isColumnIndexed(text tab, text col);
Description¶
| tab: | text Table name with or without schema component. |
|---|---|
| col: | text Column name to be checked for. |
Returns:
- true when the column “col” in table “tab” is indexed.
- false when:
- The table “tab” is not found or
- Column “col” is not found in table “tab” or
- Column “col” in table “tab” is not indexed
Histoire
- Nouveau depuis la version 2.0.0
Exemples¶
SELECT pgr_isColumnIndexed('edge_table','x1');
pgr_iscolumnindexed
---------------------
f
(1 row)
SELECT pgr_isColumnIndexed('public.edge_table','cost');
pgr_iscolumnindexed
---------------------
f
(1 row)
The example 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 in the table.
- pgr_getColumnName to get the name of the column as is stored in the postgres administration tables.
- pgr_getTableName to get the name of the table as is stored in the postgres administration tables.