Two dimentional array : Array Column « Array « PostgreSQL






  1. PostgreSQL
  2. Array
  3. Array Column

Two dimentional array

postgres=# CREATE TABLE t (
postgres(#    squares   integer[3][3]
postgres(# );
CREATE TABLE
postgres=#
postgres=# \d t;
        Table "public.t"
 Column  |   Type    | Modifiers
---------+-----------+-----------
 squares | integer[] |

postgres=#
postgres=# drop table t;
DROP TABLE
postgres=#








Related examples in the same category

1.Integer array and text array
2.Creating a table with an array column
3.Creating a table with a multidimensional array column