Results of 1 - 8 of about 8 for Properties (0.004 sec.)
- Java JDBC Client – DuckDB 13465
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...the same time. To open an existing database file in read-only mode, set the connection property duckdb.read_only like so: Properties readOnlyProperty = new Properties (); readOnlyProperty . setProperty ( "duckdb.read_only" , "true" ); Connection conn = Dr...settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. Properties connectionProperties = new Properties (); connectionProperties . setProperty ( "temp_directory" , "/path/to/temp/dir/" );...Connection conn = DriverManager . getConnection ( "jdbc:duckdb:/tmp/my_database" , connectionProperties ); Querying DuckDB supports the standard JDBC methods to send queries and retrieve result sets. First a Statement object h... - https://man.mtool.work/duckdb/1.3/clients/java.html
- Node.js API – DuckDB 10103
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...kdb~OPEN_PRIVATECACHE : number Currently ignored Kind : inner constant of duckdb ColumnInfo : object Kind : global typedef Properties Name Type Description name string Column name type TypeInfo Column type TypeInfo : object Kind : global typedef Properties...n id string Type ID [alias] string SQL type alias sql_type string SQL type name DuckDbError : object Kind : global typedef Properties Name Type Description errno number -1 for DuckDB errors message string Error message code string 'DUCKDB_NODEJS_ERROR' for...rType string DuckDB error type code (eg, HTTP, IO, Catalog) HTTPError : object Kind : global typedef Extends : DuckDbError Properties Name Type Description statusCode number HTTP response status code reason string HTTP response reason response string HTTP... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Directly Reading Files – DuckDB 8350
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t to NULL instead. Support for Projection Pushdown The table functions also utilize projection pushdown to avoid computing properties unnecessarily. So you could e.g., use this to glob a directory full of huge files to get the file size in the size column,... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Execution Format – DuckDB 8169
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...for efficiently storing incremental sequences. They are generally emitted for row identifiers. Unified Vector Format These properties of the different vector formats are great for optimization purposes, for example you can imagine the scenario where all th... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Constraints – DuckDB 8169
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Documentation / SQL Copy Markdown Constraints In SQL, constraints can be specified for tables. Constraints enforce certain properties over data that is inserted into a table. Constraints can be specified along with the schema of the table as part of the CR... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Spatial Functions – DuckDB 7988
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...requires the JSON extension to be loaded) SELECT CAST ({ type : 'Feature' , geometry : ST_AsGeoJSON ( ST_Point ( 1 , 2 )), properties : { name : 'my_point' } } AS JSON ); ---- { "type" : "Feature" , "geometry" :{ "type" : "Point" , "coordinates" :[ 1.0 , 2....0 ]}, "properties" :{ "name" : "my_point" }} ST_AsHEXWKB Signature VARCHAR ST_AsHEXWKB ( geom GEOMETRY ) Description Returns the geometry as... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- CSV Auto Detection – DuckDB 7988
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...possible to run the CSV sniffer as a separate step using the sniff_csv(filename) function, which returns the detected CSV properties as a table with a single row. The sniff_csv function accepts an optional sample_size parameter to configure the number of... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Struct Data Type – DuckDB 7988
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...perty of that column, part3 is a property of that column Any extra parts (e.g., .part4.part5 , etc.) are always treated as properties Creating Structs with the row Function The row function can be used to automatically convert multiple columns to a single... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work