Choosing Column Data Types 326 Setting Table and Column Constraints 327 Check Constraints 327 Not-Null Constraints 328 Unique Constraints 328 Primary Keys 328 VMware Greenplum 7 Documentation VMware 555 Formatting Columns 555 VMware Greenplum 7 Documentation VMware by Broadcom 23 Representing NULL Values 555 Escaping 555 Escaping in Text Formatted Files 556 Escaping in CSV Formatted Files 556 files and Software Package 762 Writing PL/Java functions 763 SQL Declaration 763 Type Mapping 763 NULL Handling 764 Complex Types 765 Returning Complex Types 765 Functions That Return Sets 766 Returning

files and Software Package 444 Writing PL/Java functions 445 SQL Declaration 445 Type Mapping 445 NULL Handling 446 Complex Types 447 Returning Complex Types 447 Functions That Return Sets 448 Returning Choosing Column Data Types 732 Setting Table and Column Constraints 732 Check Constraints 733 Not-Null Constraints 733 Unique Constraints 733 Primary Keys 734 Foreign Keys 734 Choosing the Table Distribution Formatting Columns 850 Formatting Columns 0 Representing NULL Values 850 VMware Greenplum v6.19 Documentation VMware, Inc. 51 Representing NULL Values 0 Escaping 851 Escaping 0 Escaping in Text Formatted

Choosing Column Data Types 534 Setting Table and Column Constraints 535 Check Constraints 535 Not-Null Constraints 536 Unique Constraints 536 Primary Keys 536 Foreign Keys 536 VMware Tanzu Greenplum 725 VMware Tanzu Greenplum 6 Documentation VMware, Inc 31 Formatting Columns 725 Representing NULL Values 725 Escaping 726 Escaping in Text Formatted Files 726 Escaping in CSV Formatted Files 727 whose columns match the record type defined by base. See Note 1. select * from json_populate_record(null::myrowtype, ‘{“a”:1,“b”:2}’) a | b —+— 1 | 2 json_populate_recordset(base anyelement, from_json json)

files and Software Package 435 Writing PL/Java functions 435 SQL Declaration 436 Type Mapping 436 NULL Handling 437 Complex Types 437 Returning Complex Types 438 Functions That Return Sets 438 Returning Choosing Column Data Types 723 Setting Table and Column Constraints 723 Check Constraints 724 Not-Null Constraints 724 Unique Constraints 724 Primary Keys 725 Foreign Keys 725 Choosing the Table Distribution 841 Formatting Rows 0 Formatting Columns 841 Formatting Columns 0 Representing NULL Values 841 Representing NULL Values 0 VMware Greenplum v6.18 Documentation VMware, Inc. 50 Escaping 842 Escaping

Choosing Column Data Types 453 Setting Table and Column Constraints 453 Check Constraints 453 Not-Null Constraints 454 Unique Constraints 454 Primary Keys 454 Foreign Keys 454 Choosing the Table Distribution Using COPY 623 Formatting Data Files 624 Formatting Rows 624 Formatting Columns 624 Representing NULL Values 625 Escaping 625 Escaping in Text Formatted Files 625 Escaping in CSV Formatted Files 626 whose columns match the record type defined by base. See Note 1. select * from json_populate_record(null::myrowtype, ‘{“a”:1,“b”:2}’) a | b —+— 1 | 2 json_populate_recordset(base anyelement, from_json json)

Choosing Column Data Types 555 Setting Table and Column Constraints 555 Check Constraints 556 Not-Null Constraints 556 Unique Constraints 556 Primary Keys 556 Foreign Keys 557 Choosing the Table Distribution Using COPY 751 Formatting Data Files 751 Formatting Rows 751 Formatting Columns 752 Representing NULL Values 752 Escaping 752 Escaping in Text Formatted Files 753 Escaping in CSV Formatted Files 753 files and Software Package 960 Writing PL/Java functions 961 SQL Declaration 961 Type Mapping 962 NULL Handling 962 Complex Types 963 Returning Complex Types 963 Functions That Return Sets 964 Returning

files and Software Package 370 Writing PL/Java functions 370 SQL Declaration 371 Type Mapping 371 NULL Handling 372 Complex Types 372 Returning Complex Types 373 Functions That Return Sets 373 Returning Choosing Column Data Types 655 Setting Table and Column Constraints 655 Check Constraints 656 Not-Null Constraints 656 Unique Constraints 656 Primary Keys 657 Foreign Keys 657 Choosing the Table Distribution 773 Formatting Rows 0 Formatting Columns 773 Formatting Columns 0 Representing NULL Values 773 Representing NULL Values 0 VMware Greenplum v6.17 Documentation VMware, Inc. 46 Escaping 774 Escaping

Choosing Column Data Types 532 Setting Table and Column Constraints 532 Check Constraints 532 Not-Null Constraints 533 Unique Constraints 533 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Using COPY 723 Formatting Data Files 723 Formatting Rows 723 Formatting Columns 724 Representing NULL Values 724 Escaping 724 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 32 Escaping in Text files and Software Package 925 Writing PL/Java functions 926 SQL Declaration 926 Type Mapping 927 NULL Handling 927 Complex Types 928 Returning Complex Types 928 Functions That Return Sets 929 VMware

Choosing Column Data Types 560 Setting Table and Column Constraints 560 Check Constraints 561 Not-Null Constraints 561 Unique Constraints 561 Primary Keys 562 Foreign Keys 562 Choosing the Table Distribution Using COPY 759 Formatting Data Files 760 Formatting Rows 760 Formatting Columns 760 Representing NULL Values 761 Escaping 761 VMware Greenplum 6 Documentation VMware by Broadcom 36 Escaping in Text files and Software Package 973 Writing PL/Java functions 974 SQL Declaration 974 Type Mapping 974 NULL Handling 975 Complex Types 976 Returning Complex Types 976 Functions That Return Sets 977 Returning

Choosing Column Data Types 531 Setting Table and Column Constraints 531 Check Constraints 532 Not-Null Constraints 532 Unique Constraints 532 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Using COPY 730 Formatting Data Files 730 Formatting Rows 731 Formatting Columns 731 Representing NULL Values 731 Escaping 731 Escaping in Text Formatted Files 732 Escaping in CSV Formatted Files 732 files and Software Package 942 Writing PL/Java functions 942 SQL Declaration 943 Type Mapping 943 NULL Handling 944 Complex Types 944 Returning Complex Types 945 Functions That Return Sets 946 Returning