We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent1aad44f commit6c596c2Copy full SHA for 6c596c2
src/test/regress/expected/sequence_1.out
@@ -220,6 +220,13 @@ SELECT nextval('sequence_test2');
220
5
221
(1 row)
222
223
+-- Information schema
224
+SELECT * FROM information_schema.sequences WHERE sequence_name IN ('sequence_test2');
225
+ sequence_catalog | sequence_schema | sequence_name | data_type | numeric_precision | numeric_precision_radix | numeric_scale | start_value | minimum_value | maximum_value | increment | cycle_option
226
+------------------+-----------------+----------------+-----------+-------------------+-------------------------+---------------+-------------+---------------+---------------+-----------+--------------
227
+ regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES
228
+(1 row)
229
+
230
-- Test comments
231
COMMENT ON SEQUENCE asdf IS 'won''t work';
232
ERROR: relation "asdf" does not exist