ST_Extrude
Name
ST_Extrude — Extrude a surface to a related volume
Synopsis
    
     geometry
     
      ST_Extrude
     
     (
    
    geometry
    
     geom
    
    , float
    
     x
    
    , float
    
     y
    
    , float
    
     z
    
    
     )
    
    ;
   
Description
Availability: 2.1.0
   
    
   
   This method needs SFCGAL backend.
  
   
    
   
   This function supports 3d and will not drop the z-index.
  
   
    
   
   This function supports Polyhedral surfaces.
  
   
    
   
   This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).
  
Examples
3D images were generated using PostGIS ST_AsX3D and rendering in HTML using X3Dom HTML Javascript rendering library .
| 
        
 SELECT ST_Buffer(ST_GeomFromText('POINT(100 90)'),
  50, 'quad_segs=2'),0,0,30);
       
  
         Original octagon formed from buffering point  | 
      
        
 ST_Extrude(ST_Buffer(ST_GeomFromText('POINT(100 90)'),
 50, 'quad_segs=2'),0,0,30);
       
  
         Hexagon extruded 30 units along Z produces a PolyhedralSurfaceZ  | 
     
| 
        
 SELECT ST_GeomFromText('LINESTRING(50 50, 100 90, 95 150)')
       
  
         Original linestring  | 
      
        
 SELECT ST_Extrude(
 ST_GeomFromText('LINESTRING(50 50, 100 90, 95 150)'),0,0,10));
       
  
         LineString Extruded along Z produces a PolyhedralSurfaceZ  |