| From: | Frank Heikens <frankygoestorio(at)mac(dot)com> |
|---|---|
| To: | Agoston Postgres <agostonpostgres(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: aliases for sequences and other DB objects? |
| Date: | 2009-06-09 20:20:36 |
| Message-ID: | DCEABA60-9735-4267-AA29-E1466400EEE5@mac.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
No, it's not possible, pgSQL does't have a CREATE ALIAS -syntax
You could put this function into another function to create sort of an
alias, but that wouldn't make to much sense.
Frank
Op 9 jun 2009, om 22:03 heeft Agoston Postgres het volgende geschreven:
> Hi!
>
> Is it possible in Postgres to specify aliases for various DB
> objects, such as tables, views, sequences, etc.? (For now I would
> like to create them for sequences.)
>
> What I mean is something like in Oracle, such as
>
> create alias my_sequence_alias for my_sequence;
> select nextval('my_sequence_alias');
>
>
> Thanks!
>
> Agoston
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioana Danes | 2009-06-09 20:26:58 | Re: Duplicate key issue in a transaction block |
| Previous Message | Agoston Postgres | 2009-06-09 20:03:51 | aliases for sequences and other DB objects? |