If you make an array column in Postgres, it’s not completely obvious how you’d insert static data into it.<\/p>\n
Say you create a table like so (two int array fields):<\/p>\n
\ncreate table groups (\n id int unique,\n name varchar unique,\n member_users int[],\n member_groups int[]\n);\n<\/pre>\nYou can insert using quoted strings. Note that the quotes are apostrophes – otherwise Postgres interprets this as a column name (as if you were doing an “INSERT INTO table SELECT … FROM …”).<\/p>\n
Also note this uses “{}” braces (not [] like you’d expect on an array).<\/p>\n
\ninsert into groups values (1, 'admins', '{1,2}', '{}');\n<\/pre>\nIf you’d like, you can also cast the text to an array (this doesn’t change the behavior, but you might find it clearer)<\/p>\n
\ninsert into groups values (1, 'admins', '{1,2}'::int, '{}'::int[]);\n<\/pre>\nYou can also use spaces if you wish:<\/p>\n
\ninsert into groups values (2, 'users', '{1, 2}', '{}');\n<\/pre>\n","protected":false},"excerpt":{"rendered":"If you make an array column in Postgres, it’s not completely obvious how you’d insert static data into it. Say you create a table like so (two int array fields): create table groups ( id int unique, name varchar unique, member_users int[], member_groups int[] ); You can insert using quoted strings. Note that the quotes … <\/p>\n