Revision 1932
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql.make | ||
|---|---|---|
| 3 | 3 |
|
| 4 | 4 |
selfDir="$(dirname -- "$0")" |
| 5 | 5 |
|
| 6 |
"$selfDir/../bin/postgres_vegbien" pg_dump --schema-only --no-owner \ |
|
| 7 |
--no-privileges|grep -v -F "CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql" |
|
| 6 |
"$selfDir/../bin/postgres_vegbien" pg_dump --schema=public --schema-only \ |
|
| 7 |
--no-owner --no-privileges |
|
| schemas/vegbien.my.sql | ||
|---|---|---|
| 9 | 9 |
|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 |
-- |
|
| 13 |
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - |
|
| 14 |
-- |
|
| 15 | 12 |
|
| 16 | 13 |
|
| 17 |
|
|
| 18 |
|
|
| 19 |
|
|
| 20 | 14 |
-- |
| 21 | 15 |
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: - |
| 22 | 16 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 9 | 9 |
SET client_min_messages = warning; |
| 10 | 10 |
SET escape_string_warning = off; |
| 11 | 11 |
|
| 12 |
-- |
|
| 13 |
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - |
|
| 14 |
-- |
|
| 15 |
|
|
| 16 |
|
|
| 17 |
|
|
| 18 | 12 |
SET search_path = public, pg_catalog; |
| 19 | 13 |
|
| 20 | 14 |
-- |
Also available in: Unified diff
schemas/vegbien.sql.make: Fixed bug where data sources' schemas were also exported by exporting only the public schema. Note that this also removes the "CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql" statement, so that it doesn't have to be filtered out with `grep -v`.