Thread: aliases for sequences and other DB objects?
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 |
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
Agoston Postgres wrote: > Hi! > > Is it possible in Postgres to specify aliases for various DB objects, such as tables, views, sequences, etc.? (For nowI 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'); No. What would this be used for? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.