Name¶

pgr_isColumnInTable — Check if a column is in the table.

Synopsis¶

Returns true when the column “col” is in table “tab”.

boolean pgr_isColumnInTable(text tab, text col);

Description¶

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”

History

• New in version 2.0.0

Examples¶

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 Sample Data network.

See Also¶

• Developer’s Guide 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.