Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Table 2. Client/Server Character Set Conversions Server Character Set Available backed up and restored.) Rules Domains Operators, operator families, and operator classes Conversions Extensions Text search parsers, dictionaries, templates, and configurations Tablespaces Databases language extensions Types Sequences Functions Tables Protocols Operators and operator classes Conversions Aggregates Casts Views Materialized Views Note: Materialized view data is not restored, only

Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Table 2. Client/Server Character Set Conversions Server Character Set Available backed up and restored.) Rules Domains Operators, operator families, and operator classes Conversions Extensions Text search parsers, dictionaries, templates, and configurations Tablespaces Databases language extensions Types Sequences Functions Tables Protocols Operators and operator classes Conversions Aggregates Casts Views Materialized Views Note: Materialized view data is not restored, only

Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Table 2. Client/Server Character Set Conversions Server Character Set Available backed up and restored.) Rules Domains Operators, operator families, and operator classes Conversions Extensions Text search parsers, dictionaries, templates, and configurations Tablespaces Databases language extensions Types Sequences Functions Tables Protocols Operators and operator classes Conversions Aggregates Casts Views Materialized Views Note: Materialized view data is not restored, only

TIMESTAMP9 1856 More about TIMESTAMP9_LTZ 1856 More about TIIMESTAMP9_NTZ 1856 Supported Type Conversions 1856 Type Conversion Examples 1858 Convert BIGINT to TIMESTAMP9_LTZ 1858 Convert DATE to TIMESTAMP9_LTZ the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character Set associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions whose names match the pattern are listed. By default, only

TIMESTAMP9 1674 More about TIMESTAMP9_LTZ 1674 More about TIIMESTAMP9_NTZ 1674 Supported Type Conversions 1674 Type Conversion Examples 1676 Convert BIGINT to TIMESTAMP9_LTZ 1676 Convert DATE to TIMESTAMP9_LTZ coordinator pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions whose names match the pattern are listed. By default, only

TIMESTAMP9 1823 More about TIMESTAMP9_LTZ 1823 More about TIIMESTAMP9_NTZ 1823 Supported Type Conversions 1823 Type Conversion Examples 1825 Convert BIGINT to TIMESTAMP9_LTZ 1825 Convert DATE to TIMESTAMP9_LTZ the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Important Although associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions whose names match the pattern are listed. By default, only

TIMESTAMP9 1815 More about TIMESTAMP9_LTZ 1815 More about TIIMESTAMP9_NTZ 1816 Supported Type Conversions 1816 Type Conversion Examples 1817 Convert BIGINT to TIMESTAMP9_LTZ 1817 Convert DATE to TIMESTAMP9_LTZ the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions whose names match the pattern are listed. By default, only

the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character backed up and restored.) Rules Domains Operators, operator families, and operator classes Conversions Extensions Text search parsers, dictionaries, templates, and configurations Tablespaces Databases language extensions Types Sequences Functions Tables Protocols Operators and operator classes Conversions Aggregates Casts Views Materialized Views Note: Materialized view data is not restored, only

the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions whose names match the pattern are listed. By default, only system catalogs. Other casts must be invoked with explicit casting syntax to prevent unexpected conversions from being applied without the user’s knowledge. VMware Tanzu Greenplum 6 Documentation VMware

the master pg_conversion system catalog table. Greenplum Database comes with some predefined conversions or you can create a new conversion using the SQL command CREATE CONVERSION. Server Character associated permissions. \dc[S+] [conversion_pattern] Lists conversions between character-set encodings. If a pattern is specified, only conversions VMware Tanzu Greenplum 6 Documentation VMware, Inc 679 system catalogs. Other casts must be invoked with explicit casting syntax to prevent unexpected conversions from being applied without the user’s knowledge. You can display cast information with the psql