Selecting geometry from PostGIS compatible with Open3D

Question

I have a cube stored as geometry in a PostGIS DB. I get the coordinates using the following SQL:

select ST_AsEWKT(geom) from polyhedral.vol_1 where id = 1

This presents the following result.

POLYHEDRALSURFACE(
  ((0 1 0,0 0 0,1 0 0,1 1 0,0 1 0)),
  ((1 -0 1,0 0 1,0 1 1,1 1 1,1 -0 1)),
  ((1 0 0,1 -0 1,1 1 1,1 1 0,1 0 0)),
  ((0 0 0,0 0 1,1 -0 1,1 0 0,0 0 0)),
  ((0 1 0,0 1 1,0 0 1,0 0 0,0 1 0)),
  ((0 1 1,0 1 0,1 1 0,1 1 1,0 1 1))
)

would like to use this within the Open3D library. For .ply files it is simple mesh = read_triangle_mesh(filename.ply)

Any ideas about how I would get the PostGIS output to be compatible with Open3D?

---

Using the PostGIS python library I can get the result above into python like this.

conn = <connection details>
cur = conn.cursor()
print("connected")
cur.execute('SELECT ST_AsEWKT(geom) FROM polyhedral.vol_1 LIMIT 1')
geom = cur.fetchone()[0]
geom

---

This parses the query result into a pandas dataframe

s = geom.replace('POLYHEDRALSURFACE', '')
s = s.replace("((","|")
s = s.replace("))","|")
s = s.replace(")","")
s = s.replace("|,|",",")
s = s.replace("|","",1)
s = s.replace("(","")
s = s.replace(s[len(s)-1], '')
s = s.replace(",",";")
s = s.replace(" ",",")

test = s.split(";")

df = pd.DataFrame([sub.split(",") for sub in test], columns=['x','y','z'])