PostgreSQL Table Multiple Values

Question

So I am working in postgreSQL and I want to create a table and in one column of this table I want to have multiple values as booleans. For example:

create table if not exists x(
     Numx numeric(5) PRIMARY KEY,
     method (here for example I want method to be able to be something like this "method {a,b,c,d}"
);

So method could have either value a or b or a,b etc.

How am I able to do so?

Thanks in advance

Harry · Accepted Answer · 2016-04-06 03:47:51Z

1

Use an array type.

http://www.postgresql.org/docs/current/static/arrays.html

CREATE TABLE sal_emp (
    name            text,
    pay_by_quarter  integer[],
    schedule        text[][]
);

You can see loads of examples in the docs. I personally would only use them if I had hundreds that I wanted to store, for a few booleans I'd likely use a column each or a bitmask.

answered Apr 6, 2016 at 3:47

Harry

11.7k1 gold badge31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL Table Multiple Values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related