In Vertica 6 do this (I don't know if this is available in earlier versions):
1. \pset tuples_only
2. \o file_path/file_name.sql
3. select statement
4. \o
5. \i file_path/file_name.sql
Search found 2 matches
- Thu Feb 07, 2013 5:22 pm
- Forum: vSQL
- Topic: Remove column header info. in out file
- Replies: 6
- Views: 120465
- Wed Feb 06, 2013 10:46 pm
- Forum: New to Vertica Database Administration
- Topic: Projections linger even after dropping the table!
- Replies: 5
- Views: 10689
Re: Projections linger even after dropping the table!
I asked my teamie about it. The answer is you have to use CASCADE option along with DROP TABLE.