Re: aliases for sequences and other DB objects? - Mailing list pgsql-general

From Frank Heikens
Subject Re: aliases for sequences and other DB objects?
Date
Msg-id DCEABA60-9735-4267-AA29-E1466400EEE5@mac.com
Whole thread Raw
In response to aliases for sequences and other DB objects?  (Agoston Postgres <agostonpostgres@yahoo.com>)
List 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


pgsql-general by date:

Previous
From: Ioana Danes
Date:
Subject: Re: Duplicate key issue in a transaction block
Next
From: Alvaro Herrera
Date:
Subject: Re: aliases for sequences and other DB objects?