| From: | reina(at)nsi(dot)edu (Tony Reina) |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Alias for field name |
| Date: | 2002-03-01 00:22:56 |
| Message-ID: | f40d3195.0202281622.5125b34c@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I know this is probably a no-no, but I was just curious.
I have two databases that are almost identical. Some of the minor
differences include different field names. For instance, in one db a
field called 'cell_name' is the same (more or less) as a field called
'file_name' in another db (actually cell_name is a subset of
file_name).
Would it be possible for PostgreSQL to know that if I ask for
'file_name' in the first db that I am really talking about
'cell_name'? In other words, is there an alias declaration?
e.g. CREATE TABLE testtable (
cell_name int4 AKA file_name
);
Note that I don't think this would be true referential integrity
because 'file_name' is nowhere in the first database (it's between
them).
Thanks.
-Tony
| From | Date | Subject | |
|---|---|---|---|
| Next Message | C. Bensend | 2002-03-01 02:30:39 | E-Z question reguarding backups (PostgreSQL 7.1.2) |
| Previous Message | Judy Jecelin | 2002-02-28 21:38:24 | Postgres with FailSafe |