creating schema
Posted: Mon Jul 28, 2014 5:14 pm
Hi there,
I'm facing my wonderful first stucking phase...
I'm using the free Vertica image available from Vertica official website and I'm trying to make practise with the product documentation.
After I stopped the other dbs I created and I connected to the new db for test, I'd like to create its schema as said in the guide, before loading all the demo data (until now I've made this process only for the VMart example database).
Here's the matter:
when I enter the vsql, and i try to launch:
vmartdb=> \i vmart_define_schema.sql
it returns that there's "no such file or directory".
Where should that file be placed and why it's not present after the creation of that db?
Thanks in advance!
I'm facing my wonderful first stucking phase...
I'm using the free Vertica image available from Vertica official website and I'm trying to make practise with the product documentation.
After I stopped the other dbs I created and I connected to the new db for test, I'd like to create its schema as said in the guide, before loading all the demo data (until now I've made this process only for the VMart example database).
Here's the matter:
when I enter the vsql, and i try to launch:
vmartdb=> \i vmart_define_schema.sql
it returns that there's "no such file or directory".
Where should that file be placed and why it's not present after the creation of that db?
Thanks in advance!