Re: [GENERAL] primary key attribute

Joao Paulo Felix wrote:
>
> Hi there,
>
> I am having trouble trying to alter a class and update an column
> constraint to PRIMARY KEY. I decided to create a new table using the
> following, still it does seem work:
>
> CREATE TABLE my_table
>
>         (my_column INT PRIMARY KEY, my_column2 TEXT);
>
> Could any one help me please. Thanks in advance.
>
> Joao Paulo

I'm new to this myself, but I know there's no
PRIMARY KEY in the SQL subset supported by PostgreSQL.

You can get the same effect by
CREATE TABLE my_table (my_column INT, my_column2 TEXT);

CREATE UNIQUE INDEX my_table_my_column_key
    ON my_table(my_column);

Then you'll be guaranteed that all records will have
distinct my_column integers.  Hope this helps.