Postgresql and Relationships between tables and Primary keys.
 

Hi,

I am coming from microsoft access background, intermediate, and I was totally bowled over by the other threads that are similar to mine.

I definitely would need a more beginners response to my question, that is, if it is reasonable to ask such a thing.

I would like to duplicate a database I just setup in access but now I oould like to do it in Postgresql and I have the following questions:

What is the command I give to create a table with the following structure:
tblClients with ClientID as the primary key and then the usual fields of LastName, FirstName and MI etc.
tblClientLines with a composite primary key of ContractID and ClientID since it has a 1 to many relationship with tblClients and tblContracts.
tblContracts with ContractID as the primary key and AuthCode etc as the other fields.

Thank-you for your time and patience, any pointers or advice would be appreciated.

fuzzy.

Seeing as this is a postgreSQL question, you may want to consider finding a postgreSQL forum to ask your question.

That said, I was able to find a lot of information re: migrating many different db types to postgreSQL... See here for starters.

http://wiki.postgresql.org/wiki/Conv..._to_PostgreSQL