On Mon, 2006-09-04 at 16:54, gustavo halperin wrote: > Hello > > I need to porting many old ORACLE-oriented-SQL files and I have many > problem with this code. Sometimes the code use some types not supported > in PosgSQL like "number" or "varchar2", there fore, can I write some > type of declaration (like in c : #define alias_name name) in order to > make PosgSQL recognize these types? Or there are other solution that you > recommend to use ?
If you just need a simple solution, look up domains: http://www.postgresql.org/docs/8.1/static/sql-createdomain.html specifically: create domain varchar2 as varchar; Note that you won't have a precision argument on the varchar2, but you can put one on the varchar you use during domain creation: This works: create domain varchar2 as varchar(200); create table test (info varchar); This doesn't: create domain varchar2 as varchar; create table test (info varchar(200)); But once the tables are created, insert statements and such should work normally. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
