Revision 12660
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
1203 | 1203 |
|
1204 | 1204 |
|
1205 | 1205 |
-- |
1206 |
-- Name: drop_column(regclass[], text, boolean); Type: FUNCTION; Schema: util; Owner: - |
|
1207 |
-- |
|
1208 |
|
|
1209 |
CREATE FUNCTION drop_column(tables regclass[], col text, force boolean DEFAULT false) RETURNS void |
|
1210 |
LANGUAGE sql |
|
1211 |
AS $_$ |
|
1212 |
SELECT util.drop_column((table_, $2), $3) FROM unnest($1) table_ |
|
1213 |
$_$; |
|
1214 |
|
|
1215 |
|
|
1216 |
-- |
|
1217 |
-- Name: FUNCTION drop_column(tables regclass[], col text, force boolean); Type: COMMENT; Schema: util; Owner: - |
|
1218 |
-- |
|
1219 |
|
|
1220 |
COMMENT ON FUNCTION drop_column(tables regclass[], col text, force boolean) IS ' |
|
1221 |
idempotent |
|
1222 |
'; |
|
1223 |
|
|
1224 |
|
|
1225 |
-- |
|
1206 | 1226 |
-- Name: drop_relation(anyelement, boolean); Type: FUNCTION; Schema: util; Owner: - |
1207 | 1227 |
-- |
1208 | 1228 |
|
Also available in: Unified diff
schemas/util.sql: added drop_column(regclass[])