Skip to content

Instantly share code, notes, and snippets.

@magick93
Created September 29, 2023 19:58
Show Gist options
  • Save magick93/688b5c15f019c3549050593986ee39d6 to your computer and use it in GitHub Desktop.
Save magick93/688b5c15f019c3549050593986ee39d6 to your computer and use it in GitHub Desktop.
Error: 'character varying' cannot be found in EnumType's name.
-- DROP SCHEMA public;
CREATE SCHEMA public AUTHORIZATION pg_database_owner;
COMMENT ON SCHEMA public IS 'standard public schema';
-- DROP TYPE public."account_based_product_code_list_type";
CREATE TYPE public."account_based_product_code_list_type" AS ENUM (
'HSA',
'Parking',
'Transit',
'MedicalFSA',
'LimitedPurposeFSA',
'DependentCareFSA');
COMMENT ON TYPE public."account_based_product_code_list_type" IS 'The code classifying the type of account based product. ';
-- DROP TYPE public."action_code_list_type";
CREATE TYPE public."action_code_list_type" AS ENUM (
'Create',
'Update',
'Delete',
'Replace',
'Merge');
-- DROP DOMAIN public.addresscomponenttype;
CREATE DOMAIN public.addresscomponenttype AS addresscomponent
CONSTRAINT addresscomponenttype_check CHECK (VALUE IS NOT NULL AND 'type' IS NOT NULL AND VALUE IS NOT NULL);
-- DROP TYPE public."affiliated_organization_type_code_list_type";
CREATE TYPE public."affiliated_organization_type_code_list_type" AS ENUM (
'Professional',
'Social',
'Community',
'Non-profit',
'Religious',
'Political');
-- DROP TYPE public."agency_role_code_list_type";
CREATE TYPE public."agency_role_code_list_type" AS ENUM (
'Customer',
'Supplier',
'Requester');
COMMENT ON TYPE public."agency_role_code_list_type" IS 'A code classifying the role of an entity or the role with which that entity is associated.';
-- DROP DOMAIN public.amount_type;
CREATE DOMAIN public.amount_type AS currency_amount
CONSTRAINT amount_type_check CHECK (VALUE IS NOT NULL);
-- DROP TYPE public."approval_status_code_list_type";
CREATE TYPE public."approval_status_code_list_type" AS ENUM (
'InReview',
'Approved',
'NotApproved');
COMMENT ON TYPE public."approval_status_code_list_type" IS 'Status of the approval process for a position opening; typical values: InReview, Approved, NotApproved.';
-- DROP TYPE public."assessment_status_code_list_type";
CREATE TYPE public."assessment_status_code_list_type" AS ENUM (
'OrderAcknowledged',
'TestPendingScheduling',
'TestScheduled',
'CompletedTestPendingScoring',
'ScoredTestPendingReview',
'SubjectDeclinedTest',
'OrderComplete',
'OrderInProgress',
'OrderCancelled',
'OrderExpired',
'OrderReviewRequired',
'Deferred',
'Error');
-- DROP TYPE public."assessment_type_code_list_type";
CREATE TYPE public."assessment_type_code_list_type" AS ENUM (
'Knowledge',
'Skill',
'Ability',
'Psychometric',
'CertificationOrLicense');
-- DROP TYPE public."assignment_reason_code_list_type";
CREATE TYPE public."assignment_reason_code_list_type" AS ENUM (
'Acquisition',
'Demotion',
'Hire',
'Lateral',
'Promotion',
'Transfer',
'Re-hire',
'Retirement',
'Leave',
'Termination');
COMMENT ON TYPE public."assignment_reason_code_list_type" IS 'The reason a person is assigned to the position, e.g. Hire, Transfer, Promotion, etc. ';
-- DROP TYPE public."country_code_list_type";
CREATE TYPE public."country_code_list_type" AS ENUM (
'AD',
'AE',
'AF',
'AG',
'AI',
'AL',
'AM',
'AO',
'AQ',
'AR',
'AS',
'AT',
'AU',
'AW',
'AX',
'AZ',
'BA',
'BB',
'BD',
'BE',
'BF',
'BG',
'BH',
'BI',
'BJ',
'BL',
'BM',
'BN',
'BO',
'BR',
'BS',
'BT',
'BV',
'BW',
'BY',
'BZ',
'CA',
'CC',
'CD',
'CF',
'CG',
'CH',
'CI',
'CK',
'CL',
'CM',
'CN',
'CO',
'CR',
'CU',
'CV',
'CW',
'CX',
'CY',
'CZ',
'DE',
'DJ',
'DK',
'DM',
'DO',
'DZ',
'EC',
'EE',
'EG',
'EH',
'ER',
'ES',
'ET',
'FI',
'FJ',
'FK',
'FM',
'FO',
'FR',
'GA',
'GB',
'GD',
'GE',
'GF',
'GG',
'GH',
'GI',
'GL',
'GM',
'GN',
'GP',
'GQ',
'GR',
'GS',
'GT',
'GU',
'GW',
'GY',
'HK',
'HM',
'HN',
'HR',
'HT',
'HU',
'ID',
'IE',
'IL',
'IM',
'IN',
'IO',
'IQ',
'IR',
'IS',
'IT',
'JE',
'JM',
'JO',
'JP',
'KE',
'KG',
'KH',
'KI',
'KM',
'KN',
'KP',
'KR',
'KW',
'KY',
'KZ',
'LA',
'LB',
'LC',
'LI',
'LK',
'LR',
'LS',
'LT',
'LU',
'LV',
'LY',
'MA',
'MC',
'MD',
'ME',
'MF',
'MG',
'MH',
'MK',
'ML',
'MM',
'MN',
'MO',
'MP',
'MQ',
'MR',
'MS',
'MT',
'MU',
'MV',
'MW',
'MX',
'MY',
'MZ',
'NA',
'NC',
'NE',
'NF',
'NG',
'NI',
'NL',
'NO',
'NP',
'NR',
'NU',
'NZ',
'OM',
'PA',
'PE',
'PF',
'PG',
'PH',
'PK',
'PL',
'PM',
'PN',
'PR',
'PS',
'PT',
'PW',
'PY',
'QA',
'RE',
'RO',
'RS',
'RU',
'RW',
'SA',
'SB',
'SC',
'SD',
'SE',
'SG',
'SH',
'SI',
'SJ',
'SK',
'SL',
'SM',
'SN',
'SO',
'SR',
'SS',
'ST',
'SV',
'SX',
'SY',
'SZ',
'TC',
'TD',
'TF',
'TG',
'TH',
'TJ',
'TK',
'TL',
'TM',
'TN',
'TO',
'TR',
'TT',
'TV',
'TW',
'TZ',
'UA',
'UG',
'UM',
'US',
'UY',
'UZ',
'VA',
'VC',
'VE',
'VG',
'VI',
'VN',
'VU',
'WF',
'WS',
'YE',
'YT',
'ZA',
'ZM',
'ZW');
-- DROP TYPE public."coverage_entity_code_list_type";
CREATE TYPE public."coverage_entity_code_list_type" AS ENUM (
'Employee',
'Self',
'Spouse',
'CommonLawSpouse',
'DependentChild');
COMMENT ON TYPE public."coverage_entity_code_list_type" IS 'A code identifying coverage entity.';
-- DROP TYPE public."coverage_level_type_code_list_type";
CREATE TYPE public."coverage_level_type_code_list_type" AS ENUM (
'Salary',
'YearsOfService',
'Fixed');
COMMENT ON TYPE public."coverage_level_type_code_list_type" IS 'Coverage Level Type Code List. Version: 4.3.0';
-- DROP TYPE public."currency_code_list_type";
CREATE TYPE public."currency_code_list_type" AS ENUM (
'AED',
'AFN',
'ALL',
'AMD',
'ANG',
'AOA',
'ARS',
'AUD',
'AWG',
'AZN',
'BAM',
'BBD',
'BDT',
'BGN',
'BHD',
'BIF',
'BMD',
'BND',
'BOB',
'BOV',
'BRL',
'BSD',
'BTN',
'BWP',
'BYR',
'BZD',
'CAD',
'CDF',
'CHE',
'CHF',
'CHW',
'CLF',
'CLP',
'CNY',
'COP',
'COU',
'CRC',
'CUC',
'CUP',
'CVE',
'CZK',
'DJF',
'DKK',
'DOP',
'DZD',
'EGP',
'ERN',
'ETB',
'EUR',
'FJD',
'FKP',
'GBP',
'GEL',
'GHS',
'GIP',
'GMD',
'GNF',
'GTQ',
'GYD',
'HKD',
'HNL',
'HRK',
'HTG',
'HUF',
'IDR',
'ILS',
'INR',
'IQD',
'IRR',
'ISK',
'JMD',
'JOD',
'JPY',
'KES',
'KGS',
'KHR',
'KMF',
'KPW',
'KRW',
'KWD',
'KYD',
'KZT',
'LAK',
'LBP',
'LKR',
'LRD',
'LSL',
'LYD',
'MAD',
'MDL',
'MGA',
'MKD',
'MMK',
'MNT',
'MOP',
'MRU',
'MUR',
'MVR',
'MWK',
'MXN',
'MXV',
'MYR',
'MZN',
'NAD',
'NGN',
'NIO',
'NOK',
'NPR',
'NZD',
'OMR',
'PAB',
'PEN',
'PGK',
'PHP',
'PKR',
'PLN',
'PYG',
'QAR',
'RON',
'RSD',
'RUB',
'RWF',
'SAR',
'SBD',
'SCR',
'SDG',
'SEK',
'SGD',
'SHP',
'SLL',
'SOS',
'SRD',
'SSP',
'STN',
'SVC',
'SYP',
'SZL',
'THB',
'TJS',
'TMT',
'TND',
'TOP',
'TRY',
'TTD',
'TWD',
'TZS',
'UAH',
'UGX',
'USD',
'USN',
'UYI',
'UYU',
'UZS',
'VEF',
'VND',
'VUV',
'WST',
'XAF',
'XAG',
'XAU',
'XBA',
'XBB',
'XBC',
'XBD',
'XCD',
'XDR',
'XOF',
'XPD',
'XPF',
'XPT',
'XSU',
'XTS',
'XUA',
'XXX',
'YER',
'ZAR',
'ZMW',
'ZWL');
-- DROP DOMAIN public."day_of_month";
CREATE DOMAIN public."day_of_month" AS integer
CONSTRAINT day_of_month_check CHECK (VALUE >= 1 AND VALUE <= 31);
-- DROP TYPE public."direction_type";
CREATE TYPE public."direction_type" AS ENUM (
'Asc',
'Desc');
-- DROP TYPE public."disability_level_code_list_type";
CREATE TYPE public."disability_level_code_list_type" AS ENUM (
'1',
'2',
'3',
'4',
'5');
-- DROP TYPE public."education_degree_granted_status_code_list_type";
CREATE TYPE public."education_degree_granted_status_code_list_type" AS ENUM (
'Granted',
'InProgress',
'Postponed',
'NotGranted');
-- DROP TYPE public."election_frequency_code_list_type";
CREATE TYPE public."election_frequency_code_list_type" AS ENUM (
'Monthly',
'Annually');
-- DROP TYPE public."email_content_type";
CREATE TYPE public."email_content_type" AS ENUM (
'richtext',
'html',
'plain',
'markdown');
-- DROP TYPE public."employer_contribution_code_list_type";
CREATE TYPE public."employer_contribution_code_list_type" AS ENUM (
'Flat',
'Percent');
COMMENT ON TYPE public."employer_contribution_code_list_type" IS 'A code identifying type of employer contribution.';
-- DROP TYPE public."encoding_type";
CREATE TYPE public."encoding_type" AS ENUM (
'7bit',
'8bit',
'binary',
'quoted-printable',
'base64',
'ietf-token',
'x-token');
-- DROP TYPE public."fee_type";
CREATE TYPE public."fee_type" AS ENUM (
'hourly',
'contingency',
'retainer',
'fixed',
'success');
-- DROP TYPE public."form_layout";
CREATE TYPE public."form_layout" AS ENUM (
'VerticalLayout',
'HorizontalLayout',
'Group',
'Categorization',
'Control');
-- DROP TYPE public."gender_code_list_type";
CREATE TYPE public."gender_code_list_type" AS ENUM (
'Male',
'Female',
'X');
-- DROP TYPE public."geographic_responsibility_code_list_type";
CREATE TYPE public."geographic_responsibility_code_list_type" AS ENUM (
'Global',
'National',
'Regional',
'Local');
-- DROP TYPE public.ghstore;
CREATE TYPE public.ghstore (
INPUT = ghstore_in,
OUTPUT = ghstore_out,
ALIGNMENT = 4,
STORAGE = plain,
CATEGORY = U,
DELIMITER = ',');
-- DROP TYPE public."grant_type";
CREATE TYPE public."grant_type" AS ENUM (
'Performance',
'Annual',
'Signon',
'Retention');
-- DROP TYPE public."hire_type";
CREATE TYPE public."hire_type" AS ENUM (
'NewHire',
'Rehire',
'Acquisition',
'Transfer');
-- DROP TYPE public."hstore";
CREATE TYPE public."hstore" (
INPUT = hstore_in,
OUTPUT = hstore_out,
RECEIVE = hstore_recv,
SEND = hstore_send,
ALIGNMENT = 4,
STORAGE = any,
CATEGORY = U,
DELIMITER = ',');
-- DROP TYPE public."intensity_type";
CREATE TYPE public."intensity_type" AS ENUM (
'Low',
'Medium',
'High');
-- DROP TYPE public."invitation_party_code_list_type";
CREATE TYPE public."invitation_party_code_list_type" AS ENUM (
'Customer',
'Supplier',
'ThirdParty');
COMMENT ON TYPE public."invitation_party_code_list_type" IS 'Specifies who will send the invitation to the candidate. Options are the Customer or the Supplier.';
-- DROP TYPE public."isced_code_list_type";
CREATE TYPE public."isced_code_list_type" AS ENUM (
'0',
'1',
'2',
'3',
'4',
'5',
'6',
'7',
'8');
-- DROP TYPE public."item_type_code_type";
CREATE TYPE public."item_type_code_type" AS ENUM (
'Regular',
'Illness',
'Vacation',
'SpecialLeave',
'Holiday',
'Break',
'ClockAction',
'Training',
'Unscheduled',
'Compensation',
'Overtime',
'Travel',
'Pickup');
-- DROP TYPE public."language_code_list_type";
CREATE TYPE public."language_code_list_type" AS ENUM (
'aa',
'ab',
'ae',
'af',
'af-ZA',
'ak',
'am',
'am-ET',
'an',
'ar',
'ar-AE',
'ar-BH',
'ar-DZ',
'ar-EG',
'ar-IQ',
'ar-JO',
'ar-KW',
'ar-LB',
'ar-LY',
'ar-MA',
'ar-OM',
'ar-QA',
'ar-SA',
'ar-SY',
'ar-TN',
'ar-YE',
'arn',
'arn-CL',
'as',
'as-IN',
'av',
'ay',
'az',
'az-Cyrl',
'az-Cyrl-AZ',
'az-Latn',
'az-Latn-AZ',
'ba',
'ba-RU',
'be',
'be-BY',
'bg',
'bg-BG',
'bh',
'bi',
'bm',
'bn',
'bn-BD',
'bn-IN',
'bo',
'bo-CN',
'br',
'br-FR',
'bs',
'bs, hr, or sr',
'bs-Cyrl',
'bs-Cyrl-BA',
'bs-Latn',
'bs-Latn-BA',
'ca',
'ca-ES',
'ca-ES-valencia',
'ce',
'ch',
'chr',
'chr-Cher',
'chr-Cher-US',
'co',
'co-FR',
'cr',
'cs',
'cs-CZ',
'cu',
'cv',
'cy',
'cy-GB',
'da',
'da-DK',
'de',
'de-AT',
'de-CH',
'de-DE',
'de-LI',
'de-LU',
'dsb or hsb',
'dsb',
'dsb-DE',
'dv',
'dv-MV',
'dz',
'ee',
'el',
'el-GR',
'en',
'en-029',
'en-AU',
'en-BZ',
'en-CA',
'en-GB',
'en-HK',
'en-IE',
'en-IN',
'en-JM',
'en-MY',
'en-NZ',
'en-PH',
'en-SG',
'en-TT',
'en-US',
'en-ZA',
'en-ZW',
'eo',
'es',
'es-419',
'es-AR',
'es-BO',
'es-CL',
'es-CO',
'es-CR',
'es-DO',
'es-EC',
'es-ES',
'es-ES_tradnl',
'es-GT',
'es-HN',
'es-MX',
'es-NI',
'es-PA',
'es-PE',
'es-PR',
'es-PY',
'es-SV',
'es-US',
'es-UY',
'es-VE',
'et',
'et-EE',
'eu',
'eu-ES',
'fa',
'fa-IR',
'ff',
'ff-Latn',
'ff-Latn-SN',
'fi',
'fi-FI',
'fil',
'fil-PH',
'fj',
'fo',
'fo-FO',
'fr',
'fr-BE',
'fr-CA',
'fr-CD',
'fr-CH',
'fr-CI',
'fr-CM',
'fr-FR',
'fr-HT',
'fr-LU',
'fr-MA',
'fr-MC',
'fr-ML',
'fr-RE',
'fr-SN',
'fy',
'fy-NL',
'ga',
'ga-IE',
'gd',
'gd-GB',
'gl',
'gl-ES',
'gn',
'gn-PY',
'gsw',
'gsw-FR',
'gu',
'gu-IN',
'gv',
'ha',
'ha-Latn',
'ha-Latn-NG',
'haw',
'haw-US',
'he',
'he-IL',
'hi',
'hi-IN',
'ho',
'hr',
'hr-BA',
'hr-HR',
'hsb-DE',
'ht',
'hu',
'hu-HU',
'hy',
'hy-AM',
'hz',
'ia',
'id',
'id-ID',
'ie',
'ig',
'ig-NG',
'ii',
'ii-CN',
'ik',
'io',
'is',
'is-IS',
'it',
'it-CH',
'it-IT',
'iu',
'iu-Cans',
'iu-Cans-CA',
'iu-Latn',
'iu-Latn-CA',
'ja',
'ja-JP',
'jv',
'jv-Latn',
'jv-Latn-ID',
'ka',
'ka-GE',
'kg',
'ki',
'kj',
'kk',
'kk-KZ',
'kl',
'kl-GL',
'km',
'km-KH',
'kn',
'kn-IN',
'ko',
'kok',
'kok-IN',
'ko-KR',
'kr',
'ks',
'ku',
'ku-Arab',
'ku-Arab-IQ',
'kv',
'kw',
'ky',
'ky-KG',
'la',
'lb',
'lb-LU',
'lg',
'li',
'ln',
'lo',
'lo-LA',
'lt',
'lt-LT',
'lu',
'lv',
'lv-LV',
'mg',
'mg-MG',
'mh',
'mi',
'mi-NZ',
'mk',
'mk-MK',
'ml',
'ml-IN',
'mn',
'mn-Cyrl',
'mn-MN',
'mn-Mong',
'mn-Mong-CN',
'mo',
'moh',
'moh-CA',
'mr',
'mr-IN',
'ms',
'ms-BN',
'ms-MY',
'mt',
'mt-MT',
'my',
'my-MM',
'na',
'nb',
'nb-NO',
'nd',
'ne',
'ne-IN',
'ne-NP',
'ng',
'nl',
'nl-BE',
'nl-NL',
'nn',
'nn-NO',
'no',
'nqo',
'nqo-GN',
'nr',
'nso',
'nso-ZA',
'nv',
'ny',
'oc',
'oc-FR',
'oj',
'om',
'om-ET',
'or',
'or-IN',
'os',
'pa',
'pa-Arab',
'pa-Arab-PK',
'pa-IN',
'pi',
'pl',
'pl-PL',
'prs',
'prs-AF',
'ps',
'ps-AF',
'pt',
'pt-AO',
'pt-BR',
'pt-PT',
'qu',
'qut',
'qut-GT',
'quz',
'quz-BO',
'quz-EC',
'quz-PE',
'rm',
'rm-CH',
'rn',
'ro',
'ro-MD',
'ro-RO',
'ru',
'ru-RU',
'rw',
'rw-RW',
'sa',
'sah',
'sah-RU',
'sa-IN',
'sc',
'sd',
'sd-Arab',
'sd-Arab-PK',
'se',
'se-FI',
'se-NO',
'se-SE',
'sg',
'si',
'si-LK',
'sk',
'sk-SK',
'sl',
'sl-SI',
'sm',
'sma',
'sma-NO',
'sma-SE',
'smj',
'smj-NO',
'smj-SE',
'smn',
'smn-FI',
'sms',
'sms-FI',
'sn',
'sn-Latn',
'sn-Latn-ZW',
'so',
'so-SO',
'sq',
'sq-AL',
'sr',
'sr-Cyrl',
'sr-Cyrl-BA',
'sr-Cyrl-CS',
'sr-Cyrl-ME',
'sr-Cyrl-RS',
'sr-Latn',
'sr-Latn-BA',
'sr-Latn-CS',
'sr-Latn-ME',
'sr-Latn-RS',
'ss',
'st',
'st-ZA',
'su',
'sv',
'sv-FI',
'sv-SE',
'sw',
'sw-KE',
'syr',
'syr-SY',
'ta',
'ta-IN',
'ta-LK',
'te',
'te-IN',
'tg',
'tg-Cyrl',
'tg-Cyrl-TJ',
'th',
'th-TH',
'ti',
'ti-ER',
'ti-ET',
'tk',
'tk-TM',
'tl',
'tn',
'tn-BW',
'tn-ZA',
'to',
'tr',
'tr-TR',
'ts',
'ts-ZA',
'tt',
'tt-RU',
'tw',
'ty',
'tzm',
'tzm-Latn',
'tzm-Latn-DZ',
'ug',
'ug-CN',
'uk',
'uk-UA',
'ur',
'ur-IN',
'ur-PK',
'uz',
'uz-Cyrl',
'uz-Cyrl-UZ',
'uz-Latn',
'uz-Latn-UZ',
've',
'vi',
'vi-VN',
'vo',
'wa',
'wo',
'wo-SN',
'xh',
'xh-ZA',
'yi',
'yo',
'yo-NG',
'za',
'zgh',
'zgh-Tfng',
'zgh-Tfng-MA',
'zh',
'zh-CN',
'zh-Hans',
'zh-Hant',
'zh-HK',
'zh-MO',
'zh-SG',
'zh-TW',
'zu',
'zu-ZA');
-- DROP TYPE public."leave_type";
CREATE TYPE public."leave_type" AS ENUM (
'Paid',
'Unpaid');
-- DROP TYPE public."life_coverage_status_code_list_type";
CREATE TYPE public."life_coverage_status_code_list_type" AS ENUM (
'Member is active',
'Premium waived due to disability');
COMMENT ON TYPE public."life_coverage_status_code_list_type" IS 'Life Coverage Status Code List.';
-- DROP TYPE public."list_optin";
CREATE TYPE public."list_optin" AS ENUM (
'single',
'double');
-- DROP TYPE public."list_type";
CREATE TYPE public."list_type" AS ENUM (
'public',
'private',
'temporary');
-- DROP TYPE public."match_mode_type";
CREATE TYPE public."match_mode_type" AS ENUM (
'allOf',
'anyOf',
'oneOf',
'noneOf');
-- DROP DOMAIN public."month";
CREATE DOMAIN public."month" AS integer
CONSTRAINT month_check CHECK (VALUE >= 1 AND VALUE <= 12);
-- DROP TYPE public."op_type";
CREATE TYPE public."op_type" AS ENUM (
'add',
'replace',
'test');
-- DROP TYPE public."ownership_type_code_list_type";
CREATE TYPE public."ownership_type_code_list_type" AS ENUM (
'Public',
'Private',
'NonProfit',
'Government',
'Joint Venture',
'Mutual');
-- DROP TYPE public."patent_status_code_list_type";
CREATE TYPE public."patent_status_code_list_type" AS ENUM (
'Filed',
'Issued',
'Pending');
-- DROP TYPE public."pay_cycle_interval_code_list_type";
CREATE TYPE public."pay_cycle_interval_code_list_type" AS ENUM (
'Day',
'Week',
'TwoWeeks',
'HalfMonth',
'Month',
'TwoMonths',
'MonthWeek',
'MonthWeek2',
'MonthWeek3',
'MonthWeek4',
'MonthWeek5',
'MonthWeekLast',
'Quarter',
'HalfYear',
'Year');
-- DROP TYPE public."pay_rate_interval_code_list_type";
CREATE TYPE public."pay_rate_interval_code_list_type" AS ENUM (
'Hour',
'Day',
'Week',
'TwoWeek24',
'TwoWeek26',
'TwoWeeks',
'FourWeeks',
'HalfMonth',
'Month',
'TwoMonths',
'Quarter',
'SeasonalTerm',
'HalfYear',
'Year',
'QuarterToDate',
'YearToDate',
'Once');
-- DROP TYPE public."pay_type_code_list_type";
CREATE TYPE public."pay_type_code_list_type" AS ENUM (
'BasePay',
'Commission',
'Bonus',
'ShortTermIncentive',
'ShiftPay',
'OnCall',
'Hazard',
'VariablePay',
'Allowance',
'Overtime',
'Regular',
'OtherPremium',
'CallBack',
'Holiday',
'BackPay',
'Performance',
'Residual',
'Severance',
'Tip',
'OtherCompensation');
-- DROP DOMAIN public."percent";
CREATE DOMAIN public."percent" AS numeric(3,1)
CONSTRAINT percent_check CHECK (VALUE >= 0::numeric AND VALUE <= 100::numeric);
-- DROP TYPE public."period_type";
CREATE TYPE public."period_type" AS ENUM (
'Daily',
'Weekly',
'Monthly');
-- DROP TYPE public."plan_type";
CREATE TYPE public."plan_type" AS ENUM (
'Non-Qualified Option',
'Qualified Option',
'Restricted Stock / RSUs',
'Performance-Based Stock',
'Unconditional Stock',
'Phantom Stock / SARs');
-- DROP TYPE public."policy_type";
CREATE TYPE public."policy_type" AS ENUM (
'Read',
'Modify',
'Store',
'Full Control');
-- DROP TYPE public."position_schedule_type_code_list_type";
CREATE TYPE public."position_schedule_type_code_list_type" AS ENUM (
'FullTime',
'PartTime',
'FlexTime',
'SharedTime');
-- DROP TYPE public."position_status_code_list_type";
CREATE TYPE public."position_status_code_list_type" AS ENUM (
'Approved',
'Active',
'Filled',
'Frozen',
'Cancelled');
-- DROP TYPE public."position_term_type_code_list_type";
CREATE TYPE public."position_term_type_code_list_type" AS ENUM (
'Fixed',
'Permanent',
'Temporary',
'Seasonal');
-- DROP TYPE public."position_type_code_list_type";
CREATE TYPE public."position_type_code_list_type" AS ENUM (
'DirectHire',
'Temporary',
'TemporaryToHire',
'ContractToHire',
'Contract',
'Internship',
'Externship',
'Apprenticeship',
'Seasonal',
'Student',
'Volunteer');
-- DROP TYPE public."posting_requester_role_code_list_type";
CREATE TYPE public."posting_requester_role_code_list_type" AS ENUM (
'Company',
'Agency');
COMMENT ON TYPE public."posting_requester_role_code_list_type" IS 'The role of the party or person making the position posting. Version: 4.3.0';
-- DROP TYPE public."pricing_plan_interval";
CREATE TYPE public."pricing_plan_interval" AS ENUM (
'day',
'week',
'month',
'year');
-- DROP TYPE public."pricing_type";
CREATE TYPE public."pricing_type" AS ENUM (
'one_time',
'recurring');
-- DROP TYPE public."profiletype";
CREATE TYPE public."profiletype" AS ENUM (
'Public',
'Professional');
-- DROP TYPE public."pronouns_enum";
CREATE TYPE public."pronouns_enum" AS ENUM (
'he_him',
'she_her');
-- DROP TYPE public."publication_type_code_list_type";
CREATE TYPE public."publication_type_code_list_type" AS ENUM (
'Book',
'Paper',
'Article',
'Conference',
'Thesis',
'WhitePaper',
'Report',
'TechnicalDocumentation',
'Study',
'Manual',
'ResearchPaper',
'OtherPublication');
-- DROP TYPE public."rate_based_product_code_list_type";
CREATE TYPE public."rate_based_product_code_list_type" AS ENUM (
'Life',
'AD&D',
'STD',
'LTD');
-- DROP TYPE public."rate_based_product_sub_type_code_list_type";
CREATE TYPE public."rate_based_product_sub_type_code_list_type" AS ENUM (
'Basic',
'Group',
'Supplemental',
'NotApplicable');
COMMENT ON TYPE public."rate_based_product_sub_type_code_list_type" IS 'The code classifying the type of product. Version: 4.3.0';
-- DROP TYPE public."recruiting_document_status_code_list_type";
CREATE TYPE public."recruiting_document_status_code_list_type" AS ENUM (
'Active',
'Closed',
'Incomplete',
'OnHold');
COMMENT ON TYPE public."recruiting_document_status_code_list_type" IS 'Status of position opening; typical values: Active, Closed, Incomplete, OnHold. Version: 4.3.0';
-- DROP TYPE public."relationship_code_list_type";
CREATE TYPE public."relationship_code_list_type" AS ENUM (
'AdoptedChild',
'Child',
'Brother',
'Sister',
'Mother',
'Father',
'Spouse',
'Exspouse',
'Grandmother',
'Grandfather',
'Grandson',
'Granddaughter',
'LifePartner',
'ChildOfDomesticPartner');
COMMENT ON TYPE public."relationship_code_list_type" IS 'The code classifying the dependent type';
-- DROP TYPE public."relationship_type_code_list_type";
CREATE TYPE public."relationship_type_code_list_type" AS ENUM (
'Personal',
'Professional');
-- DROP TYPE public."remuneration_basis_code_list_type";
CREATE TYPE public."remuneration_basis_code_list_type" AS ENUM (
'Hourly',
'Salaried',
'SalariedPlusBonus',
'SalariedPlusCommission',
'CommissionOnly');
-- DROP TYPE public."remuneration_code_type";
CREATE TYPE public."remuneration_code_type" AS ENUM (
'Paid',
'Unpaid');
-- DROP TYPE public."request_processing_status_code_type";
CREATE TYPE public."request_processing_status_code_type" AS ENUM (
'Received',
'Validated',
'Started',
'Completed');
-- DROP TYPE public."request_result_status_code_type";
CREATE TYPE public."request_result_status_code_type" AS ENUM (
'Succeeded',
'Failed',
'PartiallyFailed');
-- DROP TYPE public."resource_relationship_code_list_type";
CREATE TYPE public."resource_relationship_code_list_type" AS ENUM (
'Employee',
'VendorEmployee',
'IndependentContractor',
'Volunteer',
'Internship',
'Externship',
'Apprenticeship');
-- DROP TYPE public."responsibility_code_list_type";
CREATE TYPE public."responsibility_code_list_type" AS ENUM (
'Unit',
'Department',
'Division',
'Parent',
'Group',
'Plant',
'Subsidiary',
'Joint Venture',
'Branch',
'Holding Affiliate');
-- DROP TYPE public."restriction_code_list_type";
CREATE TYPE public."restriction_code_list_type" AS ENUM (
'Local',
'Regional',
'Timezone',
'Country',
'Territory',
'Other');
COMMENT ON TYPE public."restriction_code_list_type" IS 'A code classifying the restriction of the remote work to a particular region or time zone. "Local" typically refers to a city or small area. "Regional" refers to a state, province or official territory. "Timezone" refers to a restriction based on time zone. "Country" refers to a restriction in one or more countries. "Territory" refers to a defined area by the company. "Other" means a restriction not defined by the other choices. If there are no restrictions, use "None". The details of the restriction should be specified in "RestrictionDetails".';
-- DROP TYPE public."result_status_code_list_type";
CREATE TYPE public."result_status_code_list_type" AS ENUM (
'Succeeded',
'Failed');
-- DROP TYPE public."score_numeric_code_list_type";
CREATE TYPE public."score_numeric_code_list_type" AS ENUM (
'Percentile',
'RawScore',
'Stanine',
'Sten',
'T-score',
'Z-score',
'IntelligenceQuotient',
'Scaled',
'NormalCurve',
'GPA');
-- DROP TYPE public."security_permission_type";
CREATE TYPE public."security_permission_type" AS ENUM (
'Read',
'Modify',
'Store',
'Full Control');
-- DROP TYPE public."service_availability_code_list_type";
CREATE TYPE public."service_availability_code_list_type" AS ENUM (
'Available',
'Unavailable',
'TemporarilyUnavailable');
COMMENT ON TYPE public."service_availability_code_list_type" IS 'Indicates availability of the package.';
-- DROP TYPE public."time_off_type_code_list_type";
CREATE TYPE public."time_off_type_code_list_type" AS ENUM (
'Administrative',
'Bereavement',
'Compensatory',
'Consolidated',
'Education',
'Family',
'PublicHoliday',
'FloatingHoliday',
'InLieuOfNotice',
'JuryDuty',
'MilitaryDuty',
'Sick',
'Vacation',
'OtherPersonal');
COMMENT ON TYPE public."time_off_type_code_list_type" IS 'The type of hours a worker took off, such as bereavement, jury duty, vacation, etc.';
-- DROP TYPE public."unit_code_list_type";
CREATE TYPE public."unit_code_list_type" AS ENUM (
'ACR',
'ARE',
'CMT',
'DAY',
'EA',
'FOT',
'GRM',
'HAR',
'HUR',
'INH',
'KGM',
'KMT',
'LTR',
'MTR',
'SMI',
'MGM',
'MLT',
'MMT',
'C26',
'MIN',
'MON',
'C62',
'ONZ',
'PTI',
'PT',
'LBR',
'QTI',
'QT',
'SEC',
'STI',
'WEE',
'YRD',
'ANN');
-- DROP SEQUENCE public.industry_id_seq;
CREATE SEQUENCE public.industry_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 2147483647
START 1
CACHE 1
NO CYCLE;
-- DROP SEQUENCE public.nz_street_address_id_seq;
CREATE SEQUENCE public.nz_street_address_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1
NO CYCLE;-- public.industry definition
-- Drop table
-- DROP TABLE public.industry;
CREATE TABLE public.industry (
id serial4 NOT NULL,
"name" varchar(255) NOT NULL,
parent_id int4 NULL,
is_sub_industry bool NOT NULL DEFAULT false,
CONSTRAINT industry_pkey PRIMARY KEY (id),
CONSTRAINT industry_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES public.industry(id)
);
CREATE OR REPLACE FUNCTION public.akeys(hstore)
RETURNS text[]
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_akeys$function$
;
CREATE OR REPLACE FUNCTION public.avals(hstore)
RETURNS text[]
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_avals$function$
;
CREATE OR REPLACE FUNCTION public.big_query_fdw_handler()
RETURNS fdw_handler
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_handler_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.big_query_fdw_meta()
RETURNS TABLE(name text, version text, author text, website text)
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_meta_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.big_query_fdw_validator(options text[], catalog oid)
RETURNS void
LANGUAGE c
AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_validator_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.click_house_fdw_handler()
RETURNS fdw_handler
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_handler_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.click_house_fdw_meta()
RETURNS TABLE(name text, version text, author text, website text)
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_meta_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.click_house_fdw_validator(options text[], catalog oid)
RETURNS void
LANGUAGE c
AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_validator_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.defined(hstore, text)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_defined$function$
;
CREATE OR REPLACE FUNCTION public.delete(hstore, text)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_delete$function$
;
CREATE OR REPLACE FUNCTION public.delete(hstore, hstore)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_delete_hstore$function$
;
CREATE OR REPLACE FUNCTION public.delete(hstore, text[])
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_delete_array$function$
;
CREATE OR REPLACE FUNCTION public.delete_old_profile()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
AS $function$
begin
delete from public.professional_profile where id = old.id;
return old;
end;
$function$
;
CREATE OR REPLACE FUNCTION public.each(hs hstore, OUT key text, OUT value text)
RETURNS SETOF record
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_each$function$
;
CREATE OR REPLACE FUNCTION public.ensure_https()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
IF NEW."Company_websitelink" IS NOT NULL AND NEW."Company_websitelink" != '' THEN
NEW."Company_websitelink" := ensure_https(NEW."Company_websitelink");
END IF;
IF NEW."Company_website" IS NOT NULL AND NEW."Company_website" != '' THEN
NEW."Company_website" := ensure_https(NEW."Company_website");
END IF;
RETURN NEW;
END;
$function$
;
CREATE OR REPLACE FUNCTION public.exist(hstore, text)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_exists$function$
;
CREATE OR REPLACE FUNCTION public.exists_all(hstore, text[])
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_exists_all$function$
;
CREATE OR REPLACE FUNCTION public.exists_any(hstore, text[])
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_exists_any$function$
;
CREATE OR REPLACE FUNCTION public.fetchval(hstore, text)
RETURNS text
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_fetchval$function$
;
CREATE OR REPLACE FUNCTION public.firebase_fdw_handler()
RETURNS fdw_handler
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_handler_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.firebase_fdw_meta()
RETURNS TABLE(name text, version text, author text, website text)
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_meta_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.firebase_fdw_validator(options text[], catalog oid)
RETURNS void
LANGUAGE c
AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_validator_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_compress(internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_compress$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_consistent(internal, hstore, smallint, oid, internal)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_consistent$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_decompress(internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_decompress$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_in(cstring)
RETURNS ghstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_in$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_options(internal)
RETURNS void
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$ghstore_options$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_out(ghstore)
RETURNS cstring
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_out$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_penalty(internal, internal, internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_penalty$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_picksplit(internal, internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_picksplit$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_same(ghstore, ghstore, internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_same$function$
;
CREATE OR REPLACE FUNCTION public.ghstore_union(internal, internal)
RETURNS ghstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$ghstore_union$function$
;
CREATE OR REPLACE FUNCTION public.gin_consistent_hstore(internal, smallint, hstore, integer, internal, internal)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$gin_consistent_hstore$function$
;
CREATE OR REPLACE FUNCTION public.gin_extract_hstore(hstore, internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$gin_extract_hstore$function$
;
CREATE OR REPLACE FUNCTION public.gin_extract_hstore_query(hstore, internal, smallint, internal, internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$gin_extract_hstore_query$function$
;
CREATE OR REPLACE FUNCTION public.handle_new_profile()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
AS $function$
begin
-- create a entry in profiles table
insert into public.user_profiles (id)
values (new.id);
-- create a entry in profiles_info table
insert into public.profiles_info (profile_id)
values (new.id);
return new;
end;
$function$
;
CREATE OR REPLACE FUNCTION public.handle_new_stripe_user()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
AS $function$
begin
insert into public.users (id, full_name, avatar_url)
values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
return new;
end;
$function$
;
CREATE OR REPLACE FUNCTION public.handle_new_user()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
SET search_path TO 'public'
AS $function$
declare
email_array_id uuid;
begin
insert into public.person (id)
values (new.id);
insert into public.communication (id)
values (new.id);
insert into public.email_type_array(communication)
values (new.id) returning id into email_array_id;
insert into public.email(address, email_type_array_id)
values (new.email, email_array_id);
return new;
end;
$function$
;
CREATE OR REPLACE FUNCTION public.handle_new_user2()
RETURNS trigger
LANGUAGE plpgsql
SECURITY DEFINER
AS $function$
begin
insert into public.professional_profile (id, avatar_url)
values (new.id, new.raw_user_meta_data->>'avatar_url');
return new;
end;
$function$
;
CREATE OR REPLACE FUNCTION public.hs_concat(hstore, hstore)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_concat$function$
;
CREATE OR REPLACE FUNCTION public.hs_contained(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_contained$function$
;
CREATE OR REPLACE FUNCTION public.hs_contains(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_contains$function$
;
CREATE OR REPLACE FUNCTION public.hstore(text, text)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$hstore_from_text$function$
;
CREATE OR REPLACE FUNCTION public.hstore(text[])
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_from_array$function$
;
CREATE OR REPLACE FUNCTION public.hstore(record)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$hstore_from_record$function$
;
CREATE OR REPLACE FUNCTION public.hstore(text[], text[])
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$hstore_from_arrays$function$
;
CREATE OR REPLACE FUNCTION public.hstore_cmp(hstore, hstore)
RETURNS integer
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_cmp$function$
;
CREATE OR REPLACE FUNCTION public.hstore_eq(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_eq$function$
;
CREATE OR REPLACE FUNCTION public.hstore_ge(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_ge$function$
;
CREATE OR REPLACE FUNCTION public.hstore_gt(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_gt$function$
;
CREATE OR REPLACE FUNCTION public.hstore_hash(hstore)
RETURNS integer
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_hash$function$
;
CREATE OR REPLACE FUNCTION public.hstore_hash_extended(hstore, bigint)
RETURNS bigint
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_hash_extended$function$
;
CREATE OR REPLACE FUNCTION public.hstore_in(cstring)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_in$function$
;
CREATE OR REPLACE FUNCTION public.hstore_le(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_le$function$
;
CREATE OR REPLACE FUNCTION public.hstore_lt(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_lt$function$
;
CREATE OR REPLACE FUNCTION public.hstore_ne(hstore, hstore)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_ne$function$
;
CREATE OR REPLACE FUNCTION public.hstore_out(hstore)
RETURNS cstring
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_out$function$
;
CREATE OR REPLACE FUNCTION public.hstore_recv(internal)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_recv$function$
;
CREATE OR REPLACE FUNCTION public.hstore_send(hstore)
RETURNS bytea
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_send$function$
;
CREATE OR REPLACE FUNCTION public.hstore_subscript_handler(internal)
RETURNS internal
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_subscript_handler$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_array(hstore)
RETURNS text[]
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_array$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_json(hstore)
RETURNS json
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_json$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_json_loose(hstore)
RETURNS json
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_json_loose$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_jsonb(hstore)
RETURNS jsonb
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_jsonb$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_jsonb_loose(hstore)
RETURNS jsonb
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_jsonb_loose$function$
;
CREATE OR REPLACE FUNCTION public.hstore_to_matrix(hstore)
RETURNS text[]
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_to_matrix$function$
;
CREATE OR REPLACE FUNCTION public.hstore_version_diag(hstore)
RETURNS integer
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_version_diag$function$
;
CREATE OR REPLACE FUNCTION public.isdefined(hstore, text)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_defined$function$
;
CREATE OR REPLACE FUNCTION public.isexists(hstore, text)
RETURNS boolean
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_exists$function$
;
CREATE OR REPLACE FUNCTION public.populate_record(anyelement, hstore)
RETURNS anyelement
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$hstore_populate_record$function$
;
CREATE OR REPLACE FUNCTION public.s3_fdw_handler()
RETURNS fdw_handler
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$s3_fdw_handler_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.s3_fdw_meta()
RETURNS TABLE(name text, version text, author text, website text)
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$s3_fdw_meta_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.s3_fdw_validator(options text[], catalog oid)
RETURNS void
LANGUAGE c
AS '$libdir/wrappers-0.1.14', $function$s3_fdw_validator_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.set_slug()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
IF NEW."Company_name" <> OLD."Company_name" OR OLD."Company_name" IS NULL THEN
NEW.slug := private.slugify(NEW."Company_name");
END IF;
RETURN NEW;
END;
$function$
;
CREATE OR REPLACE FUNCTION public.skeys(hstore)
RETURNS SETOF text
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_skeys$function$
;
CREATE OR REPLACE FUNCTION public.slice(hstore, text[])
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_slice_to_hstore$function$
;
CREATE OR REPLACE FUNCTION public.slice_array(hstore, text[])
RETURNS text[]
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_slice_to_array$function$
;
CREATE OR REPLACE FUNCTION public.stripe_fdw_handler()
RETURNS fdw_handler
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_handler_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.stripe_fdw_meta()
RETURNS TABLE(name text, version text, author text, website text)
LANGUAGE c
STRICT
AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_meta_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.stripe_fdw_validator(options text[], catalog oid)
RETURNS void
LANGUAGE c
AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_validator_wrapper$function$
;
CREATE OR REPLACE FUNCTION public.svals(hstore)
RETURNS SETOF text
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS '$libdir/hstore', $function$hstore_svals$function$
;
CREATE OR REPLACE FUNCTION public.tconvert(text, text)
RETURNS hstore
LANGUAGE c
IMMUTABLE PARALLEL SAFE
AS '$libdir/hstore', $function$hstore_from_text$function$
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment