Hello,
I have two databases, and I want the same structure, and if I change the
structure of one database it changes the structure of the other. In
documentation I saw that the syntax goes something like this: CREATE TABLE
"User" () INHERITS database2."User"; But it's not working like this, and I
couldn't find the example. Can you please write the correct example?
The other problem I have if with sequence. I have this table structure:
CREATE TABLE "Notes" (
userkey character(40) NOT NULL,
noteid SERIAL NOT NULL,
note text,
PRIMARY KEY (userkey, noteid),
FOREIGN KEY (userkey) REFERENCES "User"(userkey) ON UPDATE CASCADE ON
DELETE CASCADE
);
How can I make the noteid go from 1 to max for each user? Because if I add a
row it goes +1 for all users? How would I do that the note id would go +1
for each userkey. Do I have to make nested queries and where would I do it?
Thank you for help.
Regards,
Marko Pahić
