Results of 1 - 10 of about 36 for user name (0.004 sec.)
user (50), name (206)
- DuckDB_% Metadata Functions – DuckDB 18271
- 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
...n of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be used just like an ordinary table or...for example in the WHERE clause. Table functions are still functions, and you should write parenthesis after the function name to call it to obtain its returned resultset: SELECT * FROM duckdb_settings (); Alternatively, you may execute table functi...EGER comment A comment created by the COMMENT ON statement . VARCHAR internal true if this column built-in, false if it is user-defined. BOOLEAN column_default The default value of the column (expressed in SQL) VARCHAR is_nullable true if the column... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- MySQL Extension – DuckDB 18180
- 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
...ySQL database accessible to DuckDB use the ATTACH command with the mysql or the mysql_scanner type: ATTACH 'host=localhost user=root port=0 database=mysql' AS mysqldb ( TYPE mysql ); USE mysqldb ; Configuration The connection string determines the pa...atabase NULL MYSQL_DATABASE host localhost MYSQL_HOST password MYSQL_PWD port 0 MYSQL_TCP_PORT socket NULL MYSQL_UNIX_PORT user current user MYSQL_USER ssl_mode preferred ssl_ca ssl_capath ssl_cert ssl_cipher ssl_crl ssl_crlpath ssl_key Configuring v...For example, to connect to a different database while still using the same credentials, we can override only the database name in the following manner. ATTACH 'database=my_other_db' AS mysql_db ( TYPE mysql ); By default, created secrets are tempora... - https://man.mtool.work/duckdb/1.3/core_extensions/mysql.html
- PostgreSQL Extension – DuckDB 17685
- 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
...es_db ( TYPE postgres ); To connect to the PostgreSQL instance with the given parameters in read-only mode, run: ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db ( TYPE postgres , READ_ONLY ); By default, all schemas are attached. When wor...instances, it can be useful to only attach a specific schema. This can be accomplished using the SCHEMA command. ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db ( TYPE postgres , SCHEMA 'public' ); Configuration The ATTACH command takes a...ame=postgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [user] host Name of host to connect to localhost hostaddr Host IP address localhost passfile Name of file passwords are stored i... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- PostgreSQL Import – DuckDB 17589
- 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
...table "mytable" from the schema "public" in the database "mydb" SELECT * FROM postgres_scan ( 'host=localhost port=5432 dbname=mydb' , 'public' , 'mytable' ); The first parameter to the postgres_scan function is the PostgreSQL connection string , a...list of connection arguments provided in {key}={value} format. Below is a list of valid arguments. Name Description Default host Name of host to connect to localhost hostaddr Host IP address localhost port Port number 5432 use...r PostgreSQL user name [OS user name] password PostgreSQL password dbname Database name [user] passfile Name of file passwords are stored in... - https://man.mtool.work/duckdb/1.3/guides/database_integration/postgres.html
- Information Schema – DuckDB 17306
- 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
...ted – always NULL . VARCHAR NULL character_set_schema Currently not implemented – always NULL . VARCHAR NULL character_set_name Name of the character set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_re...pertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the encoding name. VARCHAR 'UCS' form_of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog...ture not available in DuckDB. VARCHAR NULL reference_generation Applies to a feature not available in DuckDB. VARCHAR NULL user_defined_type_catalog If the table is a typed table, the name of the database that contains the underlying data type (alway... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Node.js API – DuckDB 16775
- 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
...⇒ void .arrowIPCStream(sql, …params, callback) ⇒ .each(sql, …params, callback) ⇒ void .stream(sql, …params) .register_udf(name, return_type, fun) ⇒ void .prepare(sql, …params, callback) ⇒ Statement .exec(sql, …params, callback) ⇒ void .register_udf_...bulk(name, return_type, callback) ⇒ void .unregister_udf(name, return_type, callback) ⇒ void .register_buffer(name, array, force, ca...instance method of Connection Param Type sql …params \* connection.register_udf(name, return_type, fun) ⇒ void Register a User Defined Function Kind : instance method of Connection Note : this follows the wasm udfs somewhat but is simpler because we... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Reading Faulty CSV Files – DuckDB 16196
- 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
...es and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip faulty lines, and the possibility of stori...ng faulty lines in a temporary table to assist users with a data cleaning step. Structural Errors DuckDB supports the detection and skipping of several different structural e...section, we will go over each error with an example. For the examples, consider the following table: CREATE TABLE people ( name VARCHAR , birth_date DATE ); DuckDB detects the following error types: CAST : Casting errors occur when a column in the CS... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Azure Extension – DuckDB 16034
- 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
...my_filesystem / path /*.csv' ; Configuration Use the following configuration options how the extension reads remote files: Name Description Type Default azure_http_stats Include HTTP info from Azure Storage in the EXPLAIN ANALYZE statement . BOOLEAN...Linux, this may solve certificate issue ( Error: Invalid Error: Fail to get a new connection for: https://storage_account_name.blob.core.windows.net/. Problem with the SSL CA cert (path? access rights?) ) because when specifying the extension will t...use fully qualified path then the ACCOUNT_NAME attribute is optional. CONFIG Provider The default provider, CONFIG (i.e., user-configured), allows access to the storage account using a connection string or anonymously. For example: CREATE SECRET sec... - https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
- Utility Functions – DuckDB 14573
- 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
...lar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whether or not we...nstructs a binary-comparable sort key based on a set of input parameters and sort qualifiers. current_catalog() Return the name of the currently active catalog. Default is memory. current_database() Return the name of the currently active database. c...irst validated to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. sha1(string) Returns a VARCHAR with the SHA-1 hash of the stri... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Collations – DuckDB 14237
- 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
.... However, in Lithuanian the letter y comes between the i and j . For that reason, different collations are supported. The user must choose which collation they want to use when performing sorting and comparison operations. By default, the BINARY col.... When that column is then used in a comparison, the per-column collation is used to perform that comparison. CREATE TABLE names ( name VARCHAR COLLATE NOACCENT ); INSERT INTO names VALUES ( 'hännes' ); SELECT name FROM names WHERE name = 'hannes' ;...ot be combined. This can be problematic when you want to compare columns that have a different collation specified. SELECT name FROM names WHERE name = 'hannes' COLLATE NOCASE ; ERROR: Cannot combine types with different collation! CREATE TABLE other... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
DuckDB 1.3 Documentation / man.mtool.work