Equivalent DB2 Datataypes comapred to PostgreSQL

[robintwos]

Hi

Can anyone help me in knowing the equivalent Datatypes in DB2 for BYTEA, TEXT datatypes in PostGreSQL

and

Can I Create a ROLE in DB2 with a validity as in PostgreSQL

Here is the CREATE role syntax in PostGreSQL

CREATE ROLE XX LOGIN PASSWORD 'xxx'
NOINHERIT CREATEDB CREATEROLE
VALID UNTIL 'infinity';
Reply With Quote