classPostgreSqlProvider

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker, 'pg-17.2');
    $provider->integerLiteral(min: 42, max: 42) // => '42'

new \SqlFaker\PostgreSqlProvider(\Faker\Factory::create(), 'missing-version') // throws \RuntimeException: Unsupported

$provider = new \SqlFaker\PostgreSqlProvider(\Faker\Factory::create());
    $plan = (new \SqlFaker\Generation\Choice\BytePlanCompiler())->compile('', $provider->planner());
    $provider->generate($plan) === $provider->generate($plan) // => true

$provider = new \SqlFaker\SqliteProvider(\Faker\Factory::create());
    $plan = \SqlFaker\Generation\Plan\GenerationPlan::all()->requiringNonEmpty()->withExpansionBudget(100);
    $provider->generate($plan) !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->sql(\SqlFaker\PostgreSql\StatementType::Select, maxDepth: 0);
    preg_match('/\bSELECT\b/i', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->selectStatement(maxDepth: 0);
    preg_match('/\bSELECT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertStatement(maxDepth: 0);
    preg_match('/\bINSERT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->updateStatement(maxDepth: 0);
    preg_match('/\bUPDATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->deleteStatement(maxDepth: 0);
    preg_match('/\bDELETE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createTableStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createTableAsStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bTABLE\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createDomainStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bDOMAIN\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->alterTableStatement(maxDepth: 0);
    preg_match('/\bALTER\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->dropTableStatement(maxDepth: 0);
    preg_match('/\bDROP\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->simpleStatement(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->truncateStatement(maxDepth: 0);
    preg_match('/\bTRUNCATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->copyStatement(maxDepth: 0);
    preg_match('/\bCOPY\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createIndexStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bINDEX\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->transactionStatement(maxDepth: 0);
    preg_match('/\b(?:ABORT|BEGIN|COMMIT|ROLLBACK|START|SAVEPOINT|RELEASE|PREPARE)\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->expr(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->simpleExpr(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->literal(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $provider->whereClause(maxDepth: 0) // => ''

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->sortClause(maxDepth: 0);
    preg_match('/\bORDER\b.*\bBY\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->selectLimit(maxDepth: 0);
    preg_match('/\b(?:LIMIT|OFFSET|FETCH)\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->tableRef(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->joinedTable(maxDepth: 0);
    preg_match('/\bJOIN\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->qualifiedName(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->subquery(maxDepth: 0);
    preg_match('/\(.*\bSELECT\b.*\)/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->withClause(maxDepth: 0);
    preg_match('/\bWITH\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->foreignKeyConstraint(maxDepth: 0);
    preg_match('/\bCONSTRAINT\b.*\bFOREIGN\b.*\bREFERENCES\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->identifier(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->quotedIdentifier(minLength: 4, maxLength: 4);
    preg_match('/^"[a-z_][a-z0-9_]{3}"$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->stringLiteral(minLength: 4, maxLength: 4);
    preg_match('/^\'[A-Za-z0-9_]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $provider->integerLiteral(min: 42, max: 42) // => '42'

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->decimalLiteral(precision: 5, scale: 2);
    preg_match('/^[0-9]{1,3}\.[0-9]{2}$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->floatLiteral(precision: 5, scale: 2, minExponent: 3, maxExponent: 3);
    preg_match('/^[0-9]{1,3}\.[0-9]{2}e3$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->hexLiteral(minLength: 4, maxLength: 4);
    preg_match('/^X\'[0-9a-f]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->binaryLiteral(minLength: 4, maxLength: 4);
    preg_match('/^B\'[01]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $token = $provider->dollarQuotedString(minLength: 4, maxLength: 4);
    preg_match('/^\$\$[A-Za-z0-9_]{4}\$\$$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $provider->parameterMarker(min: 42, max: 42) // => '$42'

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertFunctionUpsertStatement(maxDepth: 0);
    preg_match('/\bINSERT\b.*\bCONFLICT\b.*\bUPDATE\b.*\(/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->partialIndexUpsertStatement(maxDepth: 0);
    preg_match('/\bCONFLICT\b.*\bWHERE\b.*\bUPDATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->domainDmlStatement(maxDepth: 0);
    preg_match('/\b(?:INSERT|UPDATE|DELETE)\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->fullTextSearchStatement(maxDepth: 0);
    preg_match('/\bSELECT\b.*@@/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->temporaryTableStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bTEMP(?:ORARY)?\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->viewStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bVIEW\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->generatedColumnStatement(maxDepth: 0);
    preg_match('/\bGENERATED\b.*\bALWAYS\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->foreignKeyCascadeStatement(maxDepth: 0);
    preg_match('/\bREFERENCES\b.*\bCASCADE\b.*\bCASCADE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->partitionOfStatement(maxDepth: 0);
    preg_match('/\bPARTITION\b.*\bOF\b.*\bVALUES\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->tableSampleStatement(maxDepth: 0);
    preg_match('/\bTABLESAMPLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->doStatement(maxDepth: 0);
    preg_match('/\bDO\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\PostgreSqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->mergeStatement(maxDepth: 0);
    preg_match('/\bMERGE\b.*\bMATCHED\b/is', $sql) // => 1