pgr_isColumnInTable¶
Nom¶
pgr_isColumnInTable — Check if a column is in the table.
Note
This function is intended for the developer’s aid.
Synopsis¶
Returns true when the column “col” is in table “tab”.
boolean pgr_isColumnInTable(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” is in table “tab”.
- false when:
- The table “tab” is not found or
- Column “col” is not found in table “tab”
Histoire
- Nouveau depuis la version 2.0.0
Exemples¶
SELECT pgr_isColumnInTable('edge_table','x1');
pgr_iscolumnintable
---------------------
t
(1 row)
SELECT pgr_isColumnInTable('public.edge_table','foo');
pgr_iscolumnintable
---------------------
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_isColumnIndexed to check if the column is indexed.
- 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.