Saturday, November 19, 2011

PostgreSQL Integer Array - Integer array field declaration

While Creating table use, 

  CREATE TABLE post_files(
file_ids integer[],
id integer,
post varchar(40));


While Altering the table,


ALTER TABLE post_files ADD COLUMN file_path_ids integer[];


Like wise we have to create the Integer array fields in the postgreSQl.





No comments:

Post a Comment