How to define primary key in PostgreSQL PGAdmin III

Today we are going to learn How to define primary key in PostgreSQL PGAdmin III. Most of time it is little confusing and different to set the primary key for the beginner programmer, as it is in MYSQL.

Here we have shared short and simple code for How to define primary key in PostgreSQL PGAdmin III :

  1. Right click on Tables field than click New Table.
  2. After that filling all the fields Properties (name) and Columns (add) tabs.
  3. On Constraints tab we can set the any column as a Primary key.

For more clear clarification please go through the snapshot below :

Facebooktwittergoogle_plusredditpinterestlinkedinmail
1 Star2 Stars3 Stars4 Stars5 Stars (13 votes, average: 4.85 out of 5)
Loading...

Leave a Reply

Your email address will not be published. Required fields are marked *