Is there a way to rename a column in a table that has uppercase characters to lower case? I tried to do it like in the following example, but I get an error saying the column already exists: dbadmin=> create table t (Capital_Letter int); CREATE TABLE dbadmin=> \d t; List of Fields by Tables Schema |...

knicely,

Thanks for your reply. Do you think I can do what you gave as an example in a tool such as Tableau?

Hi,

Is there an INSERT IGNORE option in Vertica? It's a MySQL feature that will let an insert run without error if there is a PK or UK violation.

Good afternoon, There is a function on Oracle called sql_execute that I've used to be able to execute queries that are stored in tables. We've used this as a means of limiting the queries folks can run in the database. Is this possible in vertica? For example if I store SELECT * FROM DUAL; in a tabl...

Hi,

I'm new. So what constraints are enforced? Do I even need to create them?

nnani, thank you for getting back to me. So for self-documenting purposes myself I need to comment every projection column. I suppose that makes sense, but it's hard to automate. It was easier in Oracle. Maybe Vertica needs to look into inheriting comments from the tables?

Howdy! I am new to to the forums. Please be gentle. Can I add comments to table columns? I see in the docs we can add comments to projection columns but I want a high level comment, just on the table. Is that possible? I have to say, I'm not completely sure I understand what projections are. I'm com...