terraware
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
column_exists(ptable text, pcolumn text)
Parameters
Name
Type
Mode
ptable
text
IN
pcolumn
text
IN
Definition
-- does the requested table.column exist in schema? SELECT EXISTS (SELECT NULL FROM information_schema.columns WHERE table_name = ptable AND column_name = pcolumn );