How to check if an existing table has a designated timestamp?

Question

Once I have an existing table in QuestDB, is there any way to check if the table has a designated timestamp and if yes, which column is it?

score 1 · Answer 1 · answered Apr 30 '21 at 08:53

1

There is no way as of 5.0.6 I believe. This is definitely a missing feature.

answered Apr 30 '21 at 08:53

Nick The Greek

133
5

score 1 · Accepted Answer · answered May 17 '21 at 11:51

This is possible as of version 6.0 using tables() and table_columns(). The following is an example which returns the schema of a table, including which column is set as a designated timestamp:

table_columns('my_table')

column	type	indexed	indexBlockCapacity	symbolCached	symbolCapacity	designated
symb	SYMBOL	true	1048576	false	256	false
price	DOUBLE	false	0	false	0	false
ts	TIMESTAMP	false	0	false	0	true
s	STRING	false	0	false	0	false

For more information, see the documentation for table meta functions

How to check if an existing table has a designated timestamp?

2 Answers2