Hi all,
I am a newbie to Postgresql, but I am familiar with SQL. I am
trying to add a constraint to my table using the ALTER TABLE command. The
command goes like this :
ALTER TABLE USER_SIGNUP ADD
CONSTRAINTP_USER_SIGNUP_USER_ID PRIMARY KEY(user_id);
But it is returning the error
ERROR
Hi all,
I tried:SELECT * FROM
DB1.MY_TABLE;from DB2 and it did not like the syntax. I
assume that you cannot select across database/schemas.Is this
correct?
Shiva
Hi,
I have a question. I tried adding a Foreign Key constraint to
a table via the ALTER TABLE command. But the records in the table did not match
with those in the Parent table. Now my Alter table command, instead of giving me
an error of kind - 'records do not match', has gone into a k
