Revision 10150
Added by Aaron Marcuse-Kubitza over 11 years ago
| util.sql | ||
|---|---|---|
| 769 | 769 |
|
| 770 | 770 |
|
| 771 | 771 |
-- |
| 772 |
-- Name: drop_table(text); Type: FUNCTION; Schema: util; Owner: - |
|
| 773 |
-- |
|
| 774 |
|
|
| 775 |
CREATE FUNCTION drop_table(table_ text) RETURNS void |
|
| 776 |
LANGUAGE sql STRICT |
|
| 777 |
AS $_$ |
|
| 778 |
SELECT util.eval($$DROP TABLE IF EXISTS $$||$1) |
|
| 779 |
$_$; |
|
| 780 |
|
|
| 781 |
|
|
| 782 |
-- |
|
| 783 |
-- Name: FUNCTION drop_table(table_ text); Type: COMMENT; Schema: util; Owner: - |
|
| 784 |
-- |
|
| 785 |
|
|
| 786 |
COMMENT ON FUNCTION drop_table(table_ text) IS 'idempotent'; |
|
| 787 |
|
|
| 788 |
|
|
| 789 |
-- |
|
| 772 | 790 |
-- Name: ensure_prefix(text, text); Type: FUNCTION; Schema: util; Owner: - |
| 773 | 791 |
-- |
| 774 | 792 |
|
Also available in: Unified diff
schemas/util.sql: added drop_table()