Two dimentional array : Array Column « Array « PostgreSQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Array
4.	Constraints
5.	Cursor
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Inheritance
11.	Insert Delete Update
12.	Math Functions
13.	Postgre SQL
14.	Select Query
15.	Sequence
16.	Store Procedure Function
17.	String Functions
18.	Subquery
19.	Table
20.	Table Joins
21.	Transaction
22.	User Previliege
23.	View

PostgreSQL » Array » 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

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.