---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: fakeit
excerpt: |
DuckDB Community Extensions
The FakeIt Extension enables generation of realistic fake/test data directly in SQL queries
extension:
name: fakeit
description: The FakeIt Extension enables generation of realistic fake/test data directly in SQL queries
version: 0.4.0
language: Rust
build: cargo
license: MIT
excluded_platforms: "wasm_mvp;wasm_eh;wasm_threads;linux_amd64_musl"
requires_toolchains: "rust;python3"
maintainers:
- tobilg
repo:
github: tobilg/duckdb-fakeit
ref: 80c90e4a2d9ad70f4686e524289046200d8111e2
variegata: c79cd614a75a3800e94cd640b2663d0a82ceee53
docs:
hello_world: |
-- Generate a simple fake name and email
D SELECT fakeit_name_full() as name, fakeit_contact_email() as email;
┌─────────────────┬──────────────────────────┐
│ name │ email │
│ varchar │ varchar │
├─────────────────┼──────────────────────────┤
│ Jane Doe │ jane.doe@example.com │
└─────────────────┴──────────────────────────┘
-- Generate fake address data
D SELECT fakeit_address_street() as street, fakeit_address_city() as city, fakeit_address_state() as state, fakeit_address_zip() as zip;
┌─────────────────────┬──────────────┬───────────────┬─────────┐
│ street │ city │ state │ zip │
│ varchar │ varchar │ varchar │ varchar │
├─────────────────────┼──────────────┼───────────────┼─────────┤
│ 123 Main St │ New York │ New York │ 10001 │
└─────────────────────┴──────────────┴───────────────┴─────────┘
-- Generate fake company and contact information
D SELECT fakeit_company_company() as company, fakeit_contact_phone_formatted() as phone, fakeit_internet_domain_name() as website;
┌──────────────────┬──────────────────┬─────────────────────┐
│ company │ phone │ website │
│ varchar │ varchar │ varchar │
├──────────────────┼──────────────────┼─────────────────────┤
│ Acme Corp │ (555) 123-4567 │ example.com │
└──────────────────┴──────────────────┴─────────────────────┘
-- Generate UUIDs
D SELECT fakeit_uuid_v4() as id;
┌──────────────────────────────────────┐
│ id │
│ varchar │
├──────────────────────────────────────┤
│ a1b2c3d4-e5f6-7890-abcd-ef1234567890 │
└──────────────────────────────────────┘
-- Generate fake payment information
D SELECT fakeit_payment_credit_card_type() as card_type, fakeit_payment_credit_card_number() as card_number, fakeit_payment_credit_card_cvv() as cvv;
┌───────────┬──────────────────┬─────────┐
│ card_type │ card_number │ cvv │
│ varchar │ varchar │ varchar │
├───────────┼──────────────────┼─────────┤
│ Visa │ 4532123456789012 │ 123 │
└───────────┴──────────────────┴─────────┘
extended_description: |
This community extension provides over 120 functions for generating realistic fake/test data directly in SQL queries. It's powered by the fakeit Rust library and is perfect for creating test datasets, populating development databases, and prototyping applications.
## Features
- **120+ fake data generation functions** across 25+ categories
- **Pure Rust implementation** with no C++ dependencies
- **WebAssembly compatible** for DuckDB-WASM environments
- **Self-contained** with no external dependencies
- **Production-ready** with CI/CD automation
## Function Categories
The extension organizes functions into the following categories:
### Address Functions
- `fakeit_address_street()` - Full street address
- `fakeit_address_street_number()` - Street number
- `fakeit_address_street_name()` - Street name
- `fakeit_address_street_prefix()` - Street prefix (e.g., "N", "S")
- `fakeit_address_street_suffix()` - Street suffix (e.g., "Ave", "St")
- `fakeit_address_city()` - City name
- `fakeit_address_state()` - State name
- `fakeit_address_state_abr()` - State abbreviation
- `fakeit_address_zip()` - ZIP/postal code
- `fakeit_address_country()` - Country name
- `fakeit_address_country_abr()` - Country abbreviation
- `fakeit_address_latitude()` - Random latitude
- `fakeit_address_longitude()` - Random longitude
- `fakeit_address_latitude_in_range(min, max)` - Latitude within range
- `fakeit_address_longitude_in_range(min, max)` - Longitude within range
### Name Functions
- `fakeit_name_first()` - First name
- `fakeit_name_last()` - Last name
- `fakeit_name_full()` - Full name (first + last)
- `fakeit_name_prefix()` - Name prefix (e.g., "Mr.", "Mrs.")
- `fakeit_name_suffix()` - Name suffix (e.g., "Jr.", "Sr.")
### Contact Functions
- `fakeit_contact_email()` - Email address
- `fakeit_contact_phone()` - Phone number (unformatted)
- `fakeit_contact_phone_formatted()` - Phone number (formatted)
### Company Functions
- `fakeit_company_company()` - Company name
- `fakeit_company_company_suffix()` - Company suffix (e.g., "Inc", "LLC")
- `fakeit_company_buzzword()` - Business buzzword
- `fakeit_company_bs()` - Business BS phrase
### Internet Functions
- `fakeit_internet_ipv4_address()` - IPv4 address
- `fakeit_internet_ipv6_address()` - IPv6 address
- `fakeit_internet_domain_name()` - Domain name
- `fakeit_internet_domain_suffix()` - Domain suffix (e.g., ".com", ".org")
- `fakeit_internet_username()` - Username
- `fakeit_internet_mac_address()` - MAC address
- `fakeit_internet_http_method()` - HTTP method (GET, POST, etc.)
### UUID Functions
- `fakeit_uuid_v1()` - UUID version 1 (timestamp-based)
- `fakeit_uuid_v4()` - UUID version 4 (random)
### Animal Functions
- `fakeit_animal_pet_name()` - Pet name
- `fakeit_animal_animal()` - Random animal
- `fakeit_animal_farm()` - Farm animal
- `fakeit_animal_cat()` - Cat breed
- `fakeit_animal_dog()` - Dog breed
### Beer Functions
- `fakeit_beer_name()` - Beer name
- `fakeit_beer_style()` - Beer style
- `fakeit_beer_hop()` - Hop variety
- `fakeit_beer_yeast()` - Yeast type
- `fakeit_beer_malt()` - Malt type
- `fakeit_beer_ibu()` - IBU (International Bitterness Units)
- `fakeit_beer_alcohol()` - Alcohol percentage
- `fakeit_beer_blg()` - Degrees Blg (Balling)
### Color Functions
- `fakeit_color_full()` - Full color name
- `fakeit_color_hex()` - Hex color code
- `fakeit_color_safe()` - Web-safe color
- `fakeit_color_rgb()` - RGB color array
### Currency Functions
- `fakeit_currency_short()` - Currency code (e.g., "USD")
- `fakeit_currency_long()` - Currency name (e.g., "US Dollar")
- `fakeit_currency_price()` - Random price
### DateTime Functions
- `fakeit_datetime_month()` - Month name
- `fakeit_datetime_day()` - Day number
- `fakeit_datetime_week_day()` - Weekday name
- `fakeit_datetime_year()` - Year
- `fakeit_datetime_hour()` - Hour
- `fakeit_datetime_minute()` - Minute
- `fakeit_datetime_second()` - Second
- `fakeit_datetime_nanosecond()` - Nanosecond
- `fakeit_datetime_timezone()` - Timezone name
- `fakeit_datetime_timezone_full()` - Full timezone name
- `fakeit_datetime_timezone_abv()` - Timezone abbreviation
- `fakeit_datetime_timezone_offset()` - Timezone offset
- `fakeit_datetime_date()` - Random date
### File Functions
- `fakeit_file_extension()` - File extension
- `fakeit_file_mime_type()` - MIME type
### Hacker Functions
- `fakeit_hacker_phrase()` - Hacker phrase
- `fakeit_hacker_abbreviation()` - Tech abbreviation
- `fakeit_hacker_adjective()` - Tech adjective
- `fakeit_hacker_noun()` - Tech noun
- `fakeit_hacker_verb()` - Tech verb
- `fakeit_hacker_ingverb()` - Tech verb (present participle)
### Hipster Functions
- `fakeit_hipster_word()` - Hipster word
- `fakeit_hipster_sentence()` - Hipster sentence
- `fakeit_hipster_paragraph()` - Hipster paragraph
### Image Functions
- `fakeit_image_url()` - Random image URL
### Job Functions
- `fakeit_job_title()` - Job title
- `fakeit_job_descriptor()` - Job descriptor
- `fakeit_job_level()` - Job level
### Language Functions
- `fakeit_language_random()` - Random language
- `fakeit_language_abbreviation()` - Language abbreviation
- `fakeit_language_programming()` - Programming language
### Log Level Functions
- `fakeit_log_level_general()` - General log level
- `fakeit_log_level_syslog()` - Syslog level
- `fakeit_log_level_apache()` - Apache log level
### Password Functions
- `fakeit_password_generate()` - Random password
### Payment Functions
- `fakeit_payment_credit_card_type()` - Credit card type
- `fakeit_payment_credit_card_number()` - Credit card number
- `fakeit_payment_credit_card_exp()` - Expiration date
- `fakeit_payment_credit_card_cvv()` - CVV code
- `fakeit_payment_credit_card_luhn_number()` - Luhn-valid number
### Person Functions
- `fakeit_person_ssn()` - Social Security Number
- `fakeit_person_gender()` - Gender
### Status Code Functions
- `fakeit_status_code_simple()` - Simple HTTP status code
- `fakeit_status_code_general()` - General HTTP status code
### User Agent Functions
- `fakeit_user_agent_chrome()` - Chrome user agent
- `fakeit_user_agent_firefox()` - Firefox user agent
- `fakeit_user_agent_safari()` - Safari user agent
- `fakeit_user_agent_opera()` - Opera user agent
- `fakeit_user_agent_random_platform()` - Random platform
- `fakeit_user_agent_linux_platform_token()` - Linux platform token
- `fakeit_user_agent_mac_platform_token()` - Mac platform token
- `fakeit_user_agent_windows_platform_token()` - Windows platform token
### Vehicle Functions
- `fakeit_vehicle_vehicle_type()` - Vehicle type
- `fakeit_vehicle_car_maker()` - Car manufacturer
- `fakeit_vehicle_car_model()` - Car model
- `fakeit_vehicle_fuel()` - Fuel type
- `fakeit_vehicle_transmission_gear()` - Transmission type
### Words Functions
- `fakeit_words_word()` - Random word
- `fakeit_words_sentence()` - Random sentence
- `fakeit_words_paragraph()` - Random paragraph
- `fakeit_words_question()` - Random question
- `fakeit_words_quote()` - Random quote
### Boolean Functions
- `fakeit_bool()` - Random boolean
### Generator Functions
- `fakeit_generator_generate()` - Custom pattern generator
## Usage Examples
### Generate Test Users
```sql
SELECT
row_number() OVER () as id,
fakeit_name_full() as name,
fakeit_contact_email() as email,
fakeit_contact_phone_formatted() as phone,
fakeit_address_city() as city,
fakeit_address_state() as state
FROM generate_series(1, 100);
```
### Generate E-commerce Orders
```sql
SELECT
fakeit_uuid_v4() as order_id,
fakeit_name_full() as customer_name,
fakeit_company_company() as vendor,
fakeit_currency_price() as amount,
fakeit_payment_credit_card_type() as payment_method,
fakeit_datetime_date() as order_date
FROM generate_series(1, 1000);
```
### Generate Log Entries
```sql
SELECT
fakeit_datetime_date() as timestamp,
fakeit_internet_ipv4_address() as ip_address,
fakeit_log_level_apache() as log_level,
fakeit_internet_http_method() as http_method,
fakeit_status_code_general() as status_code,
fakeit_user_agent_chrome() as user_agent
FROM generate_series(1, 10000);
```
### Generate GeoJSON Data
```sql
SELECT json_object(
'type', 'Feature',
'geometry', json_object(
'type', 'Point',
'coordinates', json_array(
fakeit_address_longitude(),
fakeit_address_latitude()
)
),
'properties', json_object(
'name', fakeit_name_full(),
'city', fakeit_address_city(),
'country', fakeit_address_country()
)
) as geojson
FROM generate_series(1, 50);
```
## Use Cases
- **Test Data Generation**: Populate development and test databases with realistic data
- **Prototyping**: Quickly mock up applications with sample data
- **Data Masking**: Replace sensitive production data with fake data for testing
- **Load Testing**: Generate large datasets for performance testing
- **Demos and Presentations**: Create compelling demo data for showcasing features
> This extension is experimental and actively being developed. See the repository for the latest updates and examples.
extension_star_count: 17
extension_star_count_pretty: 17
extension_download_count: 1181
extension_download_count_pretty: 1.2k
image: '/images/community_extensions/social_preview/preview_community_extension_fakeit.png'
layout: community_extension_doc
---
### Compatibility Matrix
This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Linux ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| macOS AMD64 | ✅ | ✅ | ✅ | ✅ | ❌ |
| macOS ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |
### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```
{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}
{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions
| function_name | function_type | description | comment | examples |
|------------------------------------------|---------------|----------------------------------------------------------------|------------------------------|--------------------------------------------------------|
| fakeit_address_street | scalar | Generates a random full street address. | NULL | [SELECT fakeit_address_street();] |
| fakeit_address_street_number | scalar | Generates a random street number. | NULL | [SELECT fakeit_address_street_number();] |
| fakeit_address_street_prefix | scalar | Generates a random street prefix (e.g., N, S, E, W). | NULL | [SELECT fakeit_address_street_prefix();] |
| fakeit_address_street_name | scalar | Generates a random street name. | NULL | [SELECT fakeit_address_street_name();] |
| fakeit_address_street_suffix | scalar | Generates a random street suffix (e.g., Ave, St, Rd, Blvd). | NULL | [SELECT fakeit_address_street_suffix();] |
| fakeit_address_city | scalar | Generates a random city name. | NULL | [SELECT fakeit_address_city();] |
| fakeit_address_state | scalar | Generates a random state name. | NULL | [SELECT fakeit_address_state();] |
| fakeit_address_state_abr | scalar | Generates a random state abbreviation. | NULL | [SELECT fakeit_address_state_abr();] |
| fakeit_address_zip | scalar | Generates a random ZIP/postal code. | NULL | [SELECT fakeit_address_zip();] |
| fakeit_address_country | scalar | Generates a random country name. | NULL | [SELECT fakeit_address_country();] |
| fakeit_address_country_abr | scalar | Generates a random country abbreviation. | NULL | [SELECT fakeit_address_country_abr();] |
| fakeit_address_latitude | scalar | Generates a random latitude coordinate. | NULL | [SELECT fakeit_address_latitude();] |
| fakeit_address_longitude | scalar | Generates a random longitude coordinate. | NULL | [SELECT fakeit_address_longitude();] |
| fakeit_address_latitude_in_range | scalar | Generates a random latitude within a specified range. | Takes min and max parameters | [SELECT fakeit_address_latitude_in_range(-90, 90);] |
| fakeit_address_longitude_in_range | scalar | Generates a random longitude within a specified range. | Takes min and max parameters | [SELECT fakeit_address_longitude_in_range(-180, 180);] |
| fakeit_name_first | scalar | Generates a random first name. | NULL | [SELECT fakeit_name_first();] |
| fakeit_name_last | scalar | Generates a random last name. | NULL | [SELECT fakeit_name_last();] |
| fakeit_name_full | scalar | Generates a random full name (first + last). | NULL | [SELECT fakeit_name_full();] |
| fakeit_name_prefix | scalar | Generates a random name prefix (e.g., Mr., Mrs., Dr.). | NULL | [SELECT fakeit_name_prefix();] |
| fakeit_name_suffix | scalar | Generates a random name suffix (e.g., Jr., Sr., III). | NULL | [SELECT fakeit_name_suffix();] |
| fakeit_contact_email | scalar | Generates a random email address. | NULL | [SELECT fakeit_contact_email();] |
| fakeit_contact_phone | scalar | Generates a random phone number (unformatted). | NULL | [SELECT fakeit_contact_phone();] |
| fakeit_contact_phone_formatted | scalar | Generates a random phone number (formatted). | NULL | [SELECT fakeit_contact_phone_formatted();] |
| fakeit_company_company | scalar | Generates a random company name. | NULL | [SELECT fakeit_company_company();] |
| fakeit_company_company_suffix | scalar | Generates a random company suffix (e.g., Inc, LLC, Corp). | NULL | [SELECT fakeit_company_company_suffix();] |
| fakeit_company_buzzword | scalar | Generates a random business buzzword. | NULL | [SELECT fakeit_company_buzzword();] |
| fakeit_company_bs | scalar | Generates a random business BS phrase. | NULL | [SELECT fakeit_company_bs();] |
| fakeit_internet_ipv4_address | scalar | Generates a random IPv4 address. | NULL | [SELECT fakeit_internet_ipv4_address();] |
| fakeit_internet_ipv6_address | scalar | Generates a random IPv6 address. | NULL | [SELECT fakeit_internet_ipv6_address();] |
| fakeit_internet_domain_name | scalar | Generates a random domain name. | NULL | [SELECT fakeit_internet_domain_name();] |
| fakeit_internet_domain_suffix | scalar | Generates a random domain suffix (e.g., .com, .org, .net). | NULL | [SELECT fakeit_internet_domain_suffix();] |
| fakeit_internet_username | scalar | Generates a random username. | NULL | [SELECT fakeit_internet_username();] |
| fakeit_internet_mac_address | scalar | Generates a random MAC address. | NULL | [SELECT fakeit_internet_mac_address();] |
| fakeit_internet_http_method | scalar | Generates a random HTTP method (GET, POST, PUT, DELETE, etc.). | NULL | [SELECT fakeit_internet_http_method();] |
| fakeit_uuid_v1 | scalar | Generates a UUID version 1 (timestamp-based). | NULL | [SELECT fakeit_uuid_v1();] |
| fakeit_uuid_v4 | scalar | Generates a UUID version 4 (random). | NULL | [SELECT fakeit_uuid_v4();] |
| fakeit_animal_pet_name | scalar | Generates a random pet name. | NULL | [SELECT fakeit_animal_pet_name();] |
| fakeit_animal_animal | scalar | Generates a random animal name. | NULL | [SELECT fakeit_animal_animal();] |
| fakeit_animal_farm | scalar | Generates a random farm animal name. | NULL | [SELECT fakeit_animal_farm();] |
| fakeit_animal_cat | scalar | Generates a random cat breed. | NULL | [SELECT fakeit_animal_cat();] |
| fakeit_animal_dog | scalar | Generates a random dog breed. | NULL | [SELECT fakeit_animal_dog();] |
| fakeit_beer_name | scalar | Generates a random beer name. | NULL | [SELECT fakeit_beer_name();] |
| fakeit_beer_style | scalar | Generates a random beer style. | NULL | [SELECT fakeit_beer_style();] |
| fakeit_beer_hop | scalar | Generates a random hop variety. | NULL | [SELECT fakeit_beer_hop();] |
| fakeit_beer_yeast | scalar | Generates a random yeast type. | NULL | [SELECT fakeit_beer_yeast();] |
| fakeit_beer_malt | scalar | Generates a random malt type. | NULL | [SELECT fakeit_beer_malt();] |
| fakeit_beer_ibu | scalar | Generates a random IBU (International Bitterness Units) value. | NULL | [SELECT fakeit_beer_ibu();] |
| fakeit_beer_alcohol | scalar | Generates a random alcohol percentage. | NULL | [SELECT fakeit_beer_alcohol();] |
| fakeit_beer_blg | scalar | Generates a random degrees Blg (Balling) value. | NULL | [SELECT fakeit_beer_blg();] |
| fakeit_color_full | scalar | Generates a random full color name. | NULL | [SELECT fakeit_color_full();] |
| fakeit_color_hex | scalar | Generates a random hex color code. | NULL | [SELECT fakeit_color_hex();] |
| fakeit_color_safe | scalar | Generates a random web-safe color. | NULL | [SELECT fakeit_color_safe();] |
| fakeit_color_rgb | scalar | Generates a random RGB color array. | NULL | [SELECT fakeit_color_rgb();] |
| fakeit_currency_short | scalar | Generates a random currency code (e.g., USD, EUR, GBP). | NULL | [SELECT fakeit_currency_short();] |
| fakeit_currency_long | scalar | Generates a random currency name (e.g., US Dollar, Euro). | NULL | [SELECT fakeit_currency_long();] |
| fakeit_currency_price | scalar | Generates a random price value. | NULL | [SELECT fakeit_currency_price();] |
| fakeit_datetime_month | scalar | Generates a random month name. | NULL | [SELECT fakeit_datetime_month();] |
| fakeit_datetime_day | scalar | Generates a random day number. | NULL | [SELECT fakeit_datetime_day();] |
| fakeit_datetime_week_day | scalar | Generates a random weekday name. | NULL | [SELECT fakeit_datetime_week_day();] |
| fakeit_datetime_year | scalar | Generates a random year. | NULL | [SELECT fakeit_datetime_year();] |
| fakeit_datetime_hour | scalar | Generates a random hour. | NULL | [SELECT fakeit_datetime_hour();] |
| fakeit_datetime_minute | scalar | Generates a random minute. | NULL | [SELECT fakeit_datetime_minute();] |
| fakeit_datetime_second | scalar | Generates a random second. | NULL | [SELECT fakeit_datetime_second();] |
| fakeit_datetime_nanosecond | scalar | Generates a random nanosecond. | NULL | [SELECT fakeit_datetime_nanosecond();] |
| fakeit_datetime_timezone | scalar | Generates a random timezone name. | NULL | [SELECT fakeit_datetime_timezone();] |
| fakeit_datetime_timezone_full | scalar | Generates a random full timezone name. | NULL | [SELECT fakeit_datetime_timezone_full();] |
| fakeit_datetime_timezone_abv | scalar | Generates a random timezone abbreviation. | NULL | [SELECT fakeit_datetime_timezone_abv();] |
| fakeit_datetime_timezone_offset | scalar | Generates a random timezone offset. | NULL | [SELECT fakeit_datetime_timezone_offset();] |
| fakeit_datetime_date | scalar | Generates a random date. | NULL | [SELECT fakeit_datetime_date();] |
| fakeit_file_extension | scalar | Generates a random file extension. | NULL | [SELECT fakeit_file_extension();] |
| fakeit_file_mime_type | scalar | Generates a random MIME type. | NULL | [SELECT fakeit_file_mime_type();] |
| fakeit_hacker_phrase | scalar | Generates a random hacker phrase. | NULL | [SELECT fakeit_hacker_phrase();] |
| fakeit_hacker_abbreviation | scalar | Generates a random tech abbreviation. | NULL | [SELECT fakeit_hacker_abbreviation();] |
| fakeit_hacker_adjective | scalar | Generates a random tech adjective. | NULL | [SELECT fakeit_hacker_adjective();] |
| fakeit_hacker_noun | scalar | Generates a random tech noun. | NULL | [SELECT fakeit_hacker_noun();] |
| fakeit_hacker_verb | scalar | Generates a random tech verb. | NULL | [SELECT fakeit_hacker_verb();] |
| fakeit_hacker_ingverb | scalar | Generates a random tech verb in present participle form. | NULL | [SELECT fakeit_hacker_ingverb();] |
| fakeit_hipster_word | scalar | Generates a random hipster word. | NULL | [SELECT fakeit_hipster_word();] |
| fakeit_hipster_sentence | scalar | Generates a random hipster sentence. | NULL | [SELECT fakeit_hipster_sentence();] |
| fakeit_hipster_paragraph | scalar | Generates a random hipster paragraph. | NULL | [SELECT fakeit_hipster_paragraph();] |
| fakeit_image_url | scalar | Generates a random image URL. | NULL | [SELECT fakeit_image_url();] |
| fakeit_job_title | scalar | Generates a random job title. | NULL | [SELECT fakeit_job_title();] |
| fakeit_job_descriptor | scalar | Generates a random job descriptor. | NULL | [SELECT fakeit_job_descriptor();] |
| fakeit_job_level | scalar | Generates a random job level. | NULL | [SELECT fakeit_job_level();] |
| fakeit_language_random | scalar | Generates a random language name. | NULL | [SELECT fakeit_language_random();] |
| fakeit_language_abbreviation | scalar | Generates a random language abbreviation. | NULL | [SELECT fakeit_language_abbreviation();] |
| fakeit_language_programming | scalar | Generates a random programming language name. | NULL | [SELECT fakeit_language_programming();] |
| fakeit_log_level_general | scalar | Generates a random general log level. | NULL | [SELECT fakeit_log_level_general();] |
| fakeit_log_level_syslog | scalar | Generates a random syslog level. | NULL | [SELECT fakeit_log_level_syslog();] |
| fakeit_log_level_apache | scalar | Generates a random Apache log level. | NULL | [SELECT fakeit_log_level_apache();] |
| fakeit_password_generate | scalar | Generates a random password. | NULL | [SELECT fakeit_password_generate();] |
| fakeit_payment_credit_card_type | scalar | Generates a random credit card type (Visa, MasterCard, etc.). | NULL | [SELECT fakeit_payment_credit_card_type();] |
| fakeit_payment_credit_card_number | scalar | Generates a random credit card number. | NULL | [SELECT fakeit_payment_credit_card_number();] |
| fakeit_payment_credit_card_exp | scalar | Generates a random credit card expiration date. | NULL | [SELECT fakeit_payment_credit_card_exp();] |
| fakeit_payment_credit_card_cvv | scalar | Generates a random CVV code. | NULL | [SELECT fakeit_payment_credit_card_cvv();] |
| fakeit_payment_credit_card_luhn_number | scalar | Generates a random Luhn-valid number. | NULL | [SELECT fakeit_payment_credit_card_luhn_number();] |
| fakeit_person_ssn | scalar | Generates a random Social Security Number. | NULL | [SELECT fakeit_person_ssn();] |
| fakeit_person_gender | scalar | Generates a random gender. | NULL | [SELECT fakeit_person_gender();] |
| fakeit_status_code_simple | scalar | Generates a simple HTTP status code. | NULL | [SELECT fakeit_status_code_simple();] |
| fakeit_status_code_general | scalar | Generates a general HTTP status code. | NULL | [SELECT fakeit_status_code_general();] |
| fakeit_user_agent_chrome | scalar | Generates a Chrome user agent string. | NULL | [SELECT fakeit_user_agent_chrome();] |
| fakeit_user_agent_firefox | scalar | Generates a Firefox user agent string. | NULL | [SELECT fakeit_user_agent_firefox();] |
| fakeit_user_agent_safari | scalar | Generates a Safari user agent string. | NULL | [SELECT fakeit_user_agent_safari();] |
| fakeit_user_agent_opera | scalar | Generates an Opera user agent string. | NULL | [SELECT fakeit_user_agent_opera();] |
| fakeit_user_agent_random_platform | scalar | Generates a random platform identifier. | NULL | [SELECT fakeit_user_agent_random_platform();] |
| fakeit_user_agent_linux_platform_token | scalar | Generates a Linux platform token. | NULL | [SELECT fakeit_user_agent_linux_platform_token();] |
| fakeit_user_agent_mac_platform_token | scalar | Generates a Mac platform token. | NULL | [SELECT fakeit_user_agent_mac_platform_token();] |
| fakeit_user_agent_windows_platform_token | scalar | Generates a Windows platform token. | NULL | [SELECT fakeit_user_agent_windows_platform_token();] |
| fakeit_vehicle_vehicle_type | scalar | Generates a random vehicle type. | NULL | [SELECT fakeit_vehicle_vehicle_type();] |
| fakeit_vehicle_car_maker | scalar | Generates a random car manufacturer. | NULL | [SELECT fakeit_vehicle_car_maker();] |
| fakeit_vehicle_car_model | scalar | Generates a random car model. | NULL | [SELECT fakeit_vehicle_car_model();] |
| fakeit_vehicle_fuel | scalar | Generates a random fuel type. | NULL | [SELECT fakeit_vehicle_fuel();] |
| fakeit_vehicle_transmission_gear | scalar | Generates a random transmission type. | NULL | [SELECT fakeit_vehicle_transmission_gear();] |
| fakeit_words_word | scalar | Generates a random word. | NULL | [SELECT fakeit_words_word();] |
| fakeit_words_sentence | scalar | Generates a random sentence. | NULL | [SELECT fakeit_words_sentence();] |
| fakeit_words_paragraph | scalar | Generates a random paragraph. | NULL | [SELECT fakeit_words_paragraph();] |
| fakeit_words_question | scalar | Generates a random question. | NULL | [SELECT fakeit_words_question();] |
| fakeit_words_quote | scalar | Generates a random quote. | NULL | [SELECT fakeit_words_quote();] |
| fakeit_bool | scalar | Generates a random boolean value. | NULL | [SELECT fakeit_bool();] |
| fakeit_generator_generate | scalar | Custom pattern generator for creating formatted fake data. | NULL | [SELECT fakeit_generator_generate();] |
### Overloaded Functions
This extension does not add any function overloads.
### Added Types
This extension does not add any types.
### Added Settings
| name | description | input_type | scope | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |