postgres=# select pg_column_size(0::smallint);
pg_column_size
----------------
2
(1 row)
postgres=# select pg_column_size(0::integer);
pg_column_size
----------------
4
(1 row)
postgres=# select pg_column_size(0::bigint);
pg_column_size
----------------
8
postgres=# select pg_column_size(10000000000000000::decimal(20));
pg_column_size
----------------
8
(1 row)
postgres=# select pg_column_size(1000000000000000000000001::decimal(30));
pg_column_size
----------------
20
(1 row)<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>11</maven.compiler.source>
<maven.compiler.target>11</maven.compiler.target>
</properties>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>Content-Type: text/html; charset=utf-8<meta charset="UTF-8">
cannot resolve 'test.repr'
for (String columnName: df.columns())df.schema()
$ hexdump -C -n 64 demo.db
00000000 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 |SQLite format 3.|
00000010 10 00 01 01 00 40 20 20 00 00 00 01 00 00 02 3d |.....@ .......=|
00000020 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 04 |................|
00000030 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 |................|