File: in_flatgeobuf.sql

package info (click to toggle)
postgis 3.5.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 70,052 kB
  • sloc: ansic: 162,204; sql: 93,950; xml: 53,121; cpp: 12,646; perl: 5,658; sh: 5,369; makefile: 3,434; python: 1,205; yacc: 447; lex: 151; pascal: 58
file content (12 lines) | stat: -rw-r--r-- 883 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
 
--set client_min_messages to DEBUG3;
select ST_FromFlatGeobufToTable('public', 'flatgeobuf_t1', (select ST_AsFlatGeobuf(q) fgb from (select null::geometry) q));

select 'T1', id, ST_AsText(geom) from ST_FromFlatGeobuf(null::flatgeobuf_t1,
    E'\\x6667620366676200240000001000000000000a000c000800000007000a000000000000010400000000000000000000003c00000010000000000000000000060008000400060000000c00000008000800000004000800000004000000020000009a9999999999f13fcdcccccccccc0040'::bytea
);

select 'T2', id, ST_AsText(geom) from ST_FromFlatGeobuf(null::flatgeobuf_t1,
    E'\\x6667620366676200240000001000000000000a000c000800000007000a000000000000020400000000000000000000004c00000010000000000000000000060008000400060000000c00000008000800000004000800000004000000040000009a9999999999f13fcdcccccccccc004033333333333324409a99999999193440'::bytea
);

drop table if exists public.flatgeobuf_t1;