Hello! column_default in information_schema.columns returns value with type like this

Question

PostgreSQL (English)

L M

Hello! column_default in information_schema.columns returns value with type like this

'test'::text. How i can cast any default column value to simple string?

#programming #russian

0

10.10.2023

2 ответов

14 просмотров

L M Автор вопроса

Stefanie Janine Stölting
Have you thought about reading the documentation? ...

How this is related to my question? I want some convinient way to make this SELECT substring(column_default, 2, length(column_default) - 8) FROM information_schema.columns WHERE (table_schema, table_name) = ('public', 'test') and column_name = 'test'

0

11.10.2023

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

Have you thought about reading the documentation? Even a VARCHAR is of type TEXT, but with a length constraint. And CHAR, VARCHAR, and TEXT are all strings.

0

10.10.2023

169 похожих чатов

Hello! column_default in information_schema.columns returns value with type like this

2 ответов

Похожие вопросы