search

citusdata / pg_shard

ATTENTION: pg_shard is superseded by Citus, its more powerful replacement
https://github.com/citusdata/citus
GNU Lesser General Public License v3.0
1.06k stars 63 forks source link

copy_to_distributed_table is not working #97

Closed arunnairmr closed 9 years ago

arunnairmr commented 9 years ago

copy_to_distributed_table command is not working for me.

postgres=# copy_to_distributed_table -CH -d '|' -n NULL '/home/ubuntu/customer_reviews_1998.csv' customer_reviews; ERROR: syntax error at or near "copy_to_distributed_table" LINE 1: copy_to_distributed_table -CH -d '|' -n NULL '/home/ubuntu/c...

Is there anything wrong in this command.

onderkalaci commented 9 years ago

Hey @arunnairmr,

copy_to_distributed_table is not a UDF. It is a bash script located under the bin directory of the source code.

The command looks correct, but, it needs to be executed it from the shell, such as: ./copy_to_distributed_table -CH -d '|' -n NULL '/home/ubuntu/customer_reviews_1998.csv' customer_reviews

We primarily try to use github for new feature requests and bug reports. We also have a mailing list, where these kind of discussions seems more appropriate.

Thanks for reaching out us!