Questions tagged [bytea]

Bytea is a binary string type for PostgreSQL.

1 question with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
139 views

Writing CSV directly to a BYTEA column from PostgreSQL tables

Assuming these two tables: CREATE TABLE data (day DATE, kpi INTEGER); CREATE TABLE reports (csv BYTEA); Is it possible to (pseudocode): INSERT INTO reports (csv) (SELECT to_csv(SELECT day, kpi FROM ...