toothrot/postgres_to_redshift

ERROR: syntax error at or near "permissions" (PG::SyntaxError) LINE 1: CREATE TABLE IF NOT EXISTS public.permissions ("id" integer,...

ashawley opened this issue · 0 comments

ashawley commented

I have a poorly named table in my schema called permissions that causes the command to choke because of a SQL syntax error:

~/.gem/ruby/2.2/gems/postgres_to_redshift-0.1.1/lib/postgres_to_redshift.rb:21:in `exec': ERROR:  syntax error at or near "permissions" (PG::SyntaxError)
LINE 1: CREATE TABLE IF NOT EXISTS public.permissions ("id" integer,...
                                          ^
        from ~/.gem/ruby/2.2/gems/postgres_to_redshift-0.1.1/lib/postgres_to_redshift.rb:21:in `block in update_tables'
        from ~/.gem/ruby/2.2/gems/postgres_to_redshift-0.1.1/lib/postgres_to_redshift.rb:20:in `each'
        from ~/.gem/ruby/2.2/gems/postgres_to_redshift-0.1.1/lib/postgres_to_redshift.rb:20:in `update_tables'
        from ~/.gem/ruby/2.2/gems/postgres_to_redshift-0.1.1/bin/postgres_to_redshift:5:in `<top (required)>'
        from ~/bin/postgres_to_redshift:23:in `load'
        from ~/bin/postgres_to_redshift:23:in `<main>'