Unique Constraint with foreign Key - Mailing list pgsql-sql

From mohan@physics.gmu.edu
Subject Unique Constraint with foreign Key
Date
Msg-id 64366.138.88.163.115.1076432616.squirrel@physics.gmu.edu
Whole thread Raw
Responses Re: Unique Constraint with foreign Key
List pgsql-sql
Hi all i am using postgres and torque
I have a column x in Table A of type varchar and NOT NULL. I want to
impose a unique key constraint on that table and column y is the primary
key.
I have another Table B with column x. can i make this column x as a
foreign key on column x in table A.
or Can i have varchar types  of size 50 as primary keys in Postgres.

please let me know

--Mohan




pgsql-sql by date:

Previous
From: "Kumar"
Date:
Subject: Re: Error in declaring %rowtype for recurrence
Next
From: Bruno Wolff III
Date:
Subject: Re: Unique Constraint with foreign Key