DocumentationMenuIntroductionInstallation and Quick StartSupportSupport or reporting problemAmazon Web Services (AWS)Launching a Brytlyt InstanceUsing Spot Instances (AWS)BrytLyt AMI WalkthroughConnecting to the ClusterConnecting to the DatabasepsqlPgAdminODBCpsqlODBCData Definition (DDL)TablesDefinitionCREATE TABLEExampleDescriptionShardingDROP TABLEExampleIndexesCopy TablesDatatypesNumeric TypesCharacter TypesDate/Time TypesDate InputTime InputTime Zone InputSpecial Date/Time InputsUsers and SecurityData Import and ExportSypnosisExample - ImportExample - ExportDescriptionData Manipulation (DML)SelectSynopsisExampleDescriptionViewsSynopsisDescriptionInsertSynopsisDescriptionUpdateSynopsisDescriptionDeleteSynopsisDescriptionTipLogical OperatorsComparison OperatorsNoteMathematical Functions and OperatorsDescriptionMathematical OperatorsDate/Time Functions and OperatorsDate/Time FunctionsEXTRACT, date_partDescriptionCorrelated QueryCommon Table Expression (CTE)DescriptionExampleJOINExplicit syntax (ANSI SQL-92)Implicit syntax (ANSI SQL-89)Join typeExample - explicit syntaxExample - implicit syntaxAggregate FunctionsGeneral-Purpose Aggregate FunctionsGROUPING SETS, ROLLUP and CUBEWindow functionsDescriptionExampleTechnical Support