PostgreSQL datatype ROW?

Question

When I attempt to create a table with this command:

CREATE TABLE Client(ncli char(10) not null primary key,
                    nom char(32) not null,
                    adress row(rue char(30),
                    localite char(60)),
                    cat char(2));

I get an error saying :

ERROR: syntax error at or near "row"

Why do I get the error, and how can I avoid it?

I am not aware of that syntax in Postgres. You should probably just create a separate adresses table. — Gordon Linoff
– Gordon Linoff, Commented Apr 14, 2016 at 10:51
Where in the documentation of the create table statement did you find that syntax? — user330315
– user330315, Commented Apr 14, 2016 at 12:53

Daniel E. · Accepted Answer · 2016-04-14 12:45:48Z

1

You can use row when you insert some values but I think when you create the table, you need to create a new type :

 CREATE TYPE myAdress AS (
       rue char(30),
       localite char(60)
    );

Then use it to create your table :

CREATE TABLE Client(ncli char(10) not null primary key,
                    nom char(32) not null,
                    adress myAdress,
                    cat char(2));

Here is the doc, if you want to learn more : http://www.postgresql.org/docs/9.3/static/rowtypes.html

answered Apr 14, 2016 at 12:45

Daniel E.

2,4811 gold badge16 silver badges25 bronze badges

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

1 Comment

asendjasni Over a year ago

Thank you i will try it.

Collectives™ on Stack Overflow

PostgreSQL datatype ROW?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related