The IT gal
The IT gal

Reputation: 215

QuestDB : difference between table_columns() and tables()

I am new to questdb. To check if tables contain designated timestamp column we can either use tables() or table_columns(). If this is the case then what is the difference between both.

Upvotes: 1

Views: 90

Answers (1)

Alex des Pelagos
Alex des Pelagos

Reputation: 1485

To query column you can use either

table_columns('pos')

or

SHOW COLUMNS FROM 'mytable'

tables() does not show all the columns but lists all the tables.

Upvotes: 2

Related Questions