Selecting the schema from vs_sequences gives error

[beth]

Hey,

Does this seem odd? I can select all the columns from the vs_sequences table...

Code: Select all

dbadmin=> select * from vs_sequences limit 1;
        oid        |         name         |      schema       |       owner       | cache  | cycle | ordered | increment | minvalue |      maxvalue       | curvalue | table 
-------------------+----------------------+-------------------+-------------------+--------+-------+---------+-----------+----------+---------------------+----------+-------
 45035996273823302 | company_name_stg_seq | 45035996273719012 | 45035996273704962 | 250000 | f     | f       |         1 |        1 | 9223372036854775807 |   750000 |     0
(1 row)

But if I try to just select the schema column, I get an error?!?!

Code: Select all

dbadmin=> select schema from vs_sequences limit 1;
ERROR 4856:  Syntax error at or near "schema" at character 8
LINE 1: select schema from vs_sequences limit 1;
               ^

What am I doing wrong?

[JimKnicely]

Schema is a reserved word in Vertica. It is odd that they chose to use it as a column label.

Anyway, you can query it by enclosing it in double quotes:

Code: Select all

select "schema" from vs_sequences limit 1;

[beth]

Duh Thanks, Jim!