Take the 2-minute tour ×  I have two tables with the same
structure, A and B. A certain application is written so that it
always writes the same data to both tables.  After a discussion
with a colleague about the potential to save drive space, I'm
wondering if mysql or postgresql has the ability to create on
table as an "alias", or "symlink", of another.  I want the
behaviour to be very similar to that of a soft file symlink;
where reading from either the symlink itself or it's target will
yield the same output, and writing to either will update the
target.  share|improve this question Have you considered a view
of the table? –  user1240 May 25 '12 at 23:09 In SQL Server you
could just use a view. –  JNK May 25 '12 at 23:10 Which RDBMS?
You've tagged MySQL and Postgres. Views will work in most
RDBMSes. Oracle has synonyms, which are the same as Unix
symbolic links –  Phil May 25 '12 at 23:11 MySQL and Postgres,
yes. I mention them specifically in the text as well. I thought
Views was somehow not quite what I