Re: [HACKERS] Re: [GENERAL] Foreign Keys: check_primary_function

1999-04-08 Thread Margarita Barvinok
Try this create table FOOS( opaque_id int4 NOT NULL PRIMARY KEY, name text NOT NULL, bars int4 NOT NULL, bazs int4 NOT NULL ); or this create table FOOS( opaque_id int4 NOT NULL, name text NOT NULL,

[GENERAL] dbase converter

1999-04-08 Thread Patrick Welche
Is there a dbase3 <=> postgresql converter available at all? I found dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as -p primary: Select the primary key. You have to give the exact field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key) which o

Re: [GENERAL] dbase converter

1999-04-08 Thread Oleg Broytmann
On Thu, 8 Apr 1999, Patrick Welche wrote: > Is there a dbase3 <=> postgresql converter available at all? I found > dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as > > -p primary: > Select the primary key. You have to give the exact > field-name. (Only for dbf

Re: [GENERAL] dbase converter

1999-04-08 Thread Jim Mercer
> Is there a dbase3 <=> postgresql converter available at all? I found > dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as > > -p primary: > Select the primary key. You have to give the exact > field-name. (Only for dbf2msql, Postgres95 doesn't have a primary k