Get coordinate of vertices from polygon (PostGis/Postgresql)

-- Extension PostGIS for Postgreql
-- ST_DumpPoints(Geometry):
--  Return path, geom

--select (ST_DumpPoints(the_geom)).*
--from alos_prisma

select id idPoly, path[2] numPoint, ST_X(geom) X, ST_Y(geom) Y
from
(
select id, (ST_DumpPoints(the_geom)).*
from alos_prisma
) t

-- Only First record
--select id, ST_X(geom), ST_Y(geom)
--from
--(
-- select id, (ST_DumpPoints(the_geom)).geom
-- from
-- (
--  select id, the_geom
--  from alos_prisma
--  limit 1
-- ) t1
--) t2


-- All records
--select id, ST_X(geom), ST_Y(geom)
--from
--(
-- select id, (ST_DumpPoints(the_geom)).geom
-- from alos_prisma
--) t