Book a Demo

Author Topic: Serial Data Type PostgreSQL  (Read 5177 times)

Simon Greener

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Serial Data Type PostgreSQL
« on: March 22, 2012, 10:14:38 am »
I am trying to create a primary key for a target table in PostgreSQL that has data type serial.

I cannot find in the documentation nor googling nor searching this forum how to do this.

Can someone help me please?

regards
Simon

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Serial Data Type PostgreSQL
« Reply #1 on: March 22, 2012, 11:15:31 am »
Add the serial and bigserial data types to the PostgreSQL data types.

Settings -> Database Datatypes...

Simon Greener

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Serial Data Type PostgreSQL
« Reply #2 on: March 22, 2012, 11:23:32 am »
Cool, that worked, thanks!!!
Simon