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)
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;
^