Translating MySQL CREATE TABLE syntax to Postgresql

Question

I'm new to MySQL, and would like to understand the following CREATE TABLE code:

CREATE TABLE IF NOT EXISTS label_gtin (
  LABEL_ID int NOT NULL,
  GTIN_CD varchar(13) NOT NULL,
  KEY LABEL_ID (LABEL_ID,GTIN_CD)
);

Specifically, I'd like to understand what "KEY LABEL_ID (LABEL_ID,GTIN_CD)" does, and translate this to Postgresql.

Would appreciate any help. Thanks a lot!

Have you tried reading the documentation?

mu is too short
– mu is too short

2014-10-13 05:44:45 +00:00
Commented Oct 13, 2014 at 5:44 — mu is too short
– mu is too short, Commented Oct 13, 2014 at 5:44

Venu · Accepted Answer · 2014-10-13 06:00:49Z

2

you can write given CREATE TABLE code in postgresql as shown :

CREATE TABLE IF NOT EXISTS label_gtin (
  LABEL_ID integer NOT NULL,
  GTIN_CD varchar(13) NOT NULL,
  CONSTRAINT LABEL_ID PRIMARY KEY(LABEL_ID,GTIN_CD)
);

Key (PRIMARY KEY in postgresql) is a Primary Key constraint on one or more columns whose combination is unic for records in table.

Syntax: CONSTRAINT <Constraint Name> PRIMARY KEY(<Column1>[,<Column2>,<Column3>,...])

IF NOT EXISTS: Do not throw an error if a relation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing relation is anything like the one that would have been created.

you can Refer this link for details : http://www.postgresql.org/docs/current/static/sql-createtable.html

edited Oct 13, 2014 at 6:00

user330315

answered Oct 13, 2014 at 5:59

Venu

362 bronze badges

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

Collectives™ on Stack Overflow

Translating MySQL CREATE TABLE syntax to Postgresql

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