Results of 1 - 10 of about 63 for user name (0.002 sec.)
user (81), name (278)
- Security 17362
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...plied by a quack secret, the server generates a random token at startup. The server binds to localhost only, non-local hostnames require an explicit allow_other_hostname = true . The server does not use TLS for local URIs, as TLS for localhost commun...to issue. Default Configuration Both hooks ship with built-in defaults that are suitable for local development and single-user deployments, and each is exposed as an overridable callback for deployments with stricter requirements. Out of the box, th...tion , returns the query text unchanged for every query. No further filtering happens. Both callbacks can be replaced with user-supplied code, including plain SQL macros. See the examples below. The Callback Contract Two settings hold the name of the... - https://man.mtool.work/duckdb/2.0/quack/security.html
- DuckDB_% Metadata Functions 16032
- DuckDB offers a collection 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
...for example in the WHERE clause. Table functions are still functions, and you should write parentheses after the function name to call it to obtain its returned resultset: SELECT * FROM duckdb_settings(); Alternatively, you may execute table functio...tings(); In this case too, the parentheses are mandatory. For some of the duckdb_% functions, there is also an identically named view available, which also resides in the main schema. Typically, these views do a SELECT on the duckdb_ table function w...R comment A comment created by the COMMENT ON statement . VARCHAR internal true if this column is 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/2.0/sql/meta/duckdb_table_functions.html
- PostgreSQL Import 15787
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...L 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...~/.pgpass -- Attach the PostgreSQL database using the given connection string ATTACH 'host=localhost port=5432 dbname=mydb' AS test (TYPE postgres); -- The table "tbl_name" can now be queried as if it is a regular table SELECT * FROM test.t... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- Information Schema 15403
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...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/2.0/sql/meta/information_schema.html
- PostgreSQL Extension and the Secret Manager 14851
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...tgres, USER 'postgres', PASSWORD '' ); The information from the secret will be used when ATTACH is called. We can leave the PostgreSQL...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 'dbname=my_other_db' AS postgres_db (TYPE postgres); By default, created secrets are tempo...ted using the CREATE PERSISTENT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Named secrets can be used to manage connections to multiple PostgreSQL database instances. Secrets can be given a name upon cre... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- MySQL Extension 14716
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...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; Warning Avoid including credentials, such as a password,...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 temporary... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Reading Faulty CSV Files 14172
- CSV files can come in all shapes 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 fa
...ulty lines and the possibility of storing 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 CSV...f any structural errors are encountered, the scanner will immediately stop the scanning process and throw the error to the user. These errors are designed to provide as much information as possible to allow users to evaluate them directly in their CS... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- Azure Extension 14085
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...ally, run: INSTALL AND LOAD azure; Usage Queries need a secret ; for a public container, a secret with the storage account name is enough (see the CONFIG provider ). Then you can query Azure storage as follows: Azure Blob Storage Allowed URI schemes:...* 1024; Configuration Use the following configuration options to control how the extension reads and writes remote files: Name Description Type Default azure_http_stats Include HTTP info from Azure Storage in the EXPLAIN ANALYZE statement . BOOLEAN...az:// and azure:// , dfs.core.windows.net for abfss:// and abfs:// ). 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/2.0/core_extensions/azure.html
- PostgreSQL Extension 13451
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...gres_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 workin...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'); The transaction isolation level can be set...values are READ COMMITTED , REPEATABLE READ , and SERIALIZABLE ; the default is REPEATABLE READ . ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, ISOLATION_LEVEL 'READ COMMITTED'); Warning Avoid including credentials, suc... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Collations 13315
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
.... 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'; hänne...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/2.0/sql/expressions/collations.html
DuckDB 2.0 Documentation / man.mtool.work