Search found 49 matches
- Tue Dec 10, 2013 5:57 pm
- Forum: New to Vertica Database Administration
- Topic: Rename Table Column From Upper Case to Lower case?
- Replies: 1
- Views: 7489
Rename Table Column From Upper Case to Lower case?
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 |...
- Sun Oct 27, 2013 5:31 am
- Forum: New to Vertica
- Topic: Execute queries stored as text in table
- Replies: 2
- Views: 6777
Re: Execute queries stored as text in table
knicely,
Thanks for your reply. Do you think I can do what you gave as an example in a tool such as Tableau?
Thanks for your reply. Do you think I can do what you gave as an example in a tool such as Tableau?
- Sun Oct 27, 2013 5:29 am
- Forum: New to Vertica
- Topic: INSERT IGNORE
- Replies: 3
- Views: 9899
INSERT IGNORE
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.
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.
- Wed Oct 16, 2013 7:29 pm
- Forum: New to Vertica
- Topic: Execute queries stored as text in table
- Replies: 2
- Views: 6777
Execute queries stored as text in table
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...
- Fri Oct 11, 2013 1:54 pm
- Forum: New to Vertica Database Administration
- Topic: NULL constraints are enforced but UNIQUE constraints are not
- Replies: 4
- Views: 8745
Re: NULL constraints are enforced but UNIQUE constraints are
Hi,
I'm new. So what constraints are enforced? Do I even need to create them?
I'm new. So what constraints are enforced? Do I even need to create them?
- Fri Oct 11, 2013 8:18 am
- Forum: New to Vertica Database Administration
- Topic: Comments on table columns
- Replies: 2
- Views: 6021
Re: Comments on table columns
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?
- Fri Oct 11, 2013 1:39 am
- Forum: New to Vertica Database Administration
- Topic: Comments on table columns
- Replies: 2
- Views: 6021
Comments on table columns
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...