Project "DBT-1/Postgres-XC".
The branch, master has been updated
via 5343ab78653697ec3b01693344d8b4ccc6b5b3b0 (commit)
from e8423a49d59402dad28ba1499ea3da6fc6289d92 (commit)
- Log -----------------------------------------------------------------
commit 5343ab78653697ec3b01693344d8b4ccc6b5b3b0
Author: Michael P <mic...@us...>
Date: Mon May 17 13:56:08 2010 +0900
Creation of a new SQL file to upload data directly with COPY FROM.
diff --git a/scripts/pgsql/copy.sql b/scripts/pgsql/copy.sql
new file mode 100644
index 0000000..595b48a
--- /dev/null
+++ b/scripts/pgsql/copy.sql
@@ -0,0 +1,10 @@
+-- copy dbt1 data to the cluster
+copy address from '/tmp/address.data' delimiter '>';
+copy author from '/tmp/author.data' delimiter '>';
+copy stock from '/tmp/stock.data' delimiter '>';
+copy item from '/tmp/item.data' delimiter '>';
+copy country from '/tmp/country.data' delimiter '>';
+copy customer from '/tmp/customer.data' delimiter '>';
+copy orders from '/tmp/orders.data' delimiter '>';
+copy order_line from '/tmp/order_line.data' delimiter '>';
+copy cc_xacts from '/tmp/cc_xacts.data' delimiter '>';
-----------------------------------------------------------------------
Summary of changes:
scripts/pgsql/copy.sql | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
create mode 100644 scripts/pgsql/copy.sql
hooks/post-receive
--
DBT-1/Postgres-XC
|
