I am setting up the postgresql for snowplow on EC2 instance.
I have followed all the steps and connected to the Postgresql successfully using navicat.
Now when coming to creating the atomic.events table, I am running following command in the navicat query editor:
$ cd 4-storage/postgres-storage/sql $ psql -h myhostname -U power_user -d snowplow -p portNum -f atomic-def.sql
And it is continuously giving me the error syntax error near psql or near.