Like this: dbadmin=> INSERT INTO t SELECT E'\xa0' || 'Test!' || E'\xa0'; OUTPUT-------- 1(1 row)dbadmin=> SELECT * FROM t; c----------- Some junk ▒Test!▒(2 rows)db… (View Post)

Not sure what you mean by "it parse a part of the data but not all the data"... Can you run this query without error? SELECT to_char(ts, 'YYYYMMDD')) from T; For your question &qu… (View Post)

Sure! Quick example: dbadmin=> \d T List of Fields by Tables Schema | Table | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key--------+-------+--------+-----------+------+----… (View Post)

Hi, Here's a Vertica Quick Tip that might help you out here: https://www.vertica.com/blog/finding-all-columns-storing-some-value-quick-tip/ And here is a slightly modified example to find any ta… (View Post)

Maybe this is a simpler solution? SELECT schema_name, anchortablename AS anchor_table_name, MAX(row_count) row_count, MAX(size) size FROM (SELECT schema_name, projection_name, p.anchortablename, SUM(… (View Post)