convert from MySQL to Postgre

[Anon]

i have a table structure in MySQL, like this..
CREATE TABLE ACCESS (
AUT_ID int(11) NOT NULL auto_increment,
VPE enum('0','1') default '0',
VPA enum('0','1') default '0',
ANE enum('0','1') default '0',
ANP enum('0','1') default '0',
UNI enum('0','1') default '0',
NUI enum('0','1') default '0',
MTG enum('0','1') default '0',
MTA enum('0','1') default '0',
BUS enum('0','1') default '0',
BPV enum('0','1') default '0',
TOE enum('0','1') default '0',
TOA enum('0','1') default '0',
AKD enum('0','1') default '0',
HTE enum('0','1') default '0',
HTL enum('0','1') default '0',
KDT enum('0','1') default '0',
BKO enum('0','1') default '0',
REP enum('0','1') default '0',
USR enum('0','1') default '0',
LUS enum('0','1') default '0',
UVW enum('0','1') default '0',
REGION_VPA enum('0','1') default '0',
REGION_HTL enum('0','1') default '0',
BKO_TIME_START date default '2001-01-01',
BKO_TIME_STOP date default '2001-01-01',
KDA enum('0','1') default '0',
NWS enum('0','1') default '0',
PIC enum('0','1') default '1',
MED enum('0','1') default '0',
UMD enum('0','1') default '0',
NUB enum('0','1') NOT NULL default '0',
ADB enum('0','1') NOT NULL default '0',
PRIMARY KEY (AUT_ID)
)

now how to convert to Postgre ?

[[deleted]]

ENUM for 0 and 1??

just use an int.

as for the auto_increment, I suggest you read the PostgreSQL manual about the 'serial' and 'oid', it's tricky and too much to explain here.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

You'd go:

CREATE TABLE ACCESS (
AUT_ID SERIAL,
VPE smallint default '0' CHECK VPE IN (0,1),
VPA smallint default '0' CHECK VPE IN (0,1),
ANE smallint default '0' CHECK VPE IN (0,1),

Everything else should work fine. Just think twice before using hideously non-standard types in the future!!

etc.

Although, because postgres supports true booleans, you could always just go:
CREATE TABLE ACCESS (
AUT_ID SERIAL,
VPE bool default false,
VPA bool default false,
ANE bool default false,
etc.

Chris