Revision 13598
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1028 | 1028 |
|
| 1029 | 1029 |
|
| 1030 | 1030 |
-- |
| 1031 |
-- Name: copy_data(regclass, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
| 1032 |
-- |
|
| 1033 |
|
|
| 1034 |
CREATE FUNCTION copy_data(from_ regclass, to_ regclass) RETURNS void |
|
| 1035 |
LANGUAGE sql |
|
| 1036 |
AS $_$ |
|
| 1037 |
SELECT util.eval($$INSERT INTO $$||$2||$$ SELECT * FROM $$||$1) |
|
| 1038 |
$_$; |
|
| 1039 |
|
|
| 1040 |
|
|
| 1041 |
-- |
|
| 1031 | 1042 |
-- Name: copy_struct(regclass, text); Type: FUNCTION; Schema: util; Owner: - |
| 1032 | 1043 |
-- |
| 1033 | 1044 |
|
Also available in: Unified diff
schemas/util.sql: added copy_data()