Re: [GENERAL] defining an existing Table Schema for Foreign Key Constraint - Question

2008-11-02 Thread Sam Mason
On Sun, Nov 02, 2008 at 02:30:45PM -0800, Brian714 wrote: > I would like to convert the column that used to be > "credit_card_number" from the Customers table and turn it into a "cc_id" > which is an integer that references the column "id" from the table > Creditcards. [...] > Does anyone know of a

Re: Re[GENERAL] defining an existing Table Schema for Foreign Key Constraint - Question

2008-11-02 Thread brian
Brian714 wrote: Hello everyone, I am new to the forum and fairly new to databases (particularly PostgreSQL). I have done some searching on the internet and can't really get a hold of an answer to my question. So here it goes: I am working on a Customer Purchasing-based project where I must use

Re[GENERAL] defining an existing Table Schema for Foreign Key Constraint - Question

2008-11-02 Thread Brian714
Hello everyone, I am new to the forum and fairly new to databases (particularly PostgreSQL). I have done some searching on the internet and can't really get a hold of an answer to my question. So here it goes: I am working on a Customer Purchasing-based project where I must use a database with e