Results of 1 - 10 of about 58 for PostgreSQL (0.001 sec.)
- PostgreSQL Extension 13378
- 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
...ension repository. If you would like to install and load it manually, run: INSTALL AND LOAD postgres; Connecting To make a PostgreSQL database accessible to DuckDB, use the ATTACH command with the postgres or postgres_scanner type. To connect to the public...schema of the PostgreSQL instance running on localhost in read-write mode, run: ATTACH '' AS postgres_db (TYPE postgres); To connect to the Postgre...0. Use the ATTACH statement instead. Configuration The ATTACH command takes as input either a libpq connection string or a PostgreSQL URI . Below are some example connection strings and commonly used parameters. A full list of available parameters can be f... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- PostgreSQL Compatibility 12500
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...IEEE Standard for Floating-Point Arithmetic (IEEE 754) for both division by zero and operations involving infinity values. PostgreSQL returns an error for division by zero but aligns with IEEE 754 for handling infinity values. To show the differences, run...'Infinity'::FLOAT AS x; SELECT 'Infinity'::FLOAT - 'Infinity'::FLOAT AS x; SELECT 'Infinity'::FLOAT - 1.0 AS x; Expression PostgreSQL DuckDB IEEE 754 1.0 / 0.0 error Infinity Infinity 0.0 / 0.0 error NaN NaN -1.0 / 0.0 error -Infinity -Infinity 'Infinity'...nfinity' NaN NaN NaN 'Infinity' - 1.0 Infinity Infinity Infinity Division on Integers When computing division on integers, PostgreSQL performs integer division, while DuckDB performs float division: SELECT 1 / 2 AS x; PostgreSQL returns 0 , while DuckDB re... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- PostgreSQL Import 11182
- 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
...sion for usage, use the LOAD SQL command: LOAD postgres; Usage After the postgres extension is installed, you can attach a PostgreSQL database using the ATTACH command . This allows you to query all tables stored within the PostgreSQL database as if it was...a regular database. The first parameter of ATTACH is the PostgreSQL connection string , a list of connection arguments provided in {key}={value} format. Below is a list of valid arguments. N...escription Default host Name of host to connect to localhost hostaddr Host IP address localhost port Port number 5432 user PostgreSQL user name [OS user name] password PostgreSQL password dbname Database name [user] passfile Name of file passwords are stor... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- SQL Quirks 10568
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...fically to PostgreSQL's dialect (see the “PostgreSQL Compatibility” page for exceptions). The rest may simply come down to different preferences....g., array and string indexing and slicing, and window functions ( row_number , rank , dense_rank ). However, similarly to PostgreSQL, JSON features use a zero-based indexing . Types UINT8 vs. INT8 UINT8 and INT8 are aliases to integer types of different w...ed values, INT8 corresponds to BIGINT (8 bytes). Expressions Results That May Surprise You Expression Result Note -2^2 4.0 PostgreSQL compatibility means the unary minus has higher precedence than the exponentiation operator. Use additional parentheses, e.... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- PostgreSQL Extension Functions 9865
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...s with column lists) for all attached PostgreSQL catalogs. Attached schema is going to be re-read on the next access. Parameters None. Returns A table with the following c...postgres_clear_cache() postgres_configure_pool FROM postgres_configure_pool([⟨optional named parameters⟩]) -> TABLE When a PostgreSQL database is attached, a connection pool is created for this database. This function allows to change the configuration opt...tached_db_name⟩ . This function returns an empty result. Parameters attached_db_name ( VARCHAR ): the name of the attached PostgreSQL database sql_query ( VARCHAR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this qu... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- PostgreSQL Extension and the Secret Manager 9514
- 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
...gres, USER 'postgres', PASSWORD '' ); The information from the secret will be used when ATTACH is called. We can leave the PostgreSQL connection string empty to use all of the information stored in the secret. ATTACH '' AS postgres_db (TYPE postgres); We c...an use the PostgreSQL connection string to override individual options. For example, to connect to a different database while still using the sa...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 creation. CREATE SECRET postgres_secret_one ( TYPE postgres, HOST '12... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- DuckDB Repositories 8723
- Several components of DuckDB are maintained in separate repositories. Main Repositories duckdb : core DuckDB project duckdb-web : documentation and blog duckdb-quack : Quack remote protocol Clients duckdb-go : Go client duckdb-java : Java (
...ement for dplyr in R DuckDB.jl : Julia client Connectors dbt-duckdb : dbt duckdb-mysql : MySQL connector duckdb-postgres : PostgreSQL connector (connect to PostgreSQL from DuckDB) duckdb-sqlite : SQLite connector pg_duckdb : official PostgreSQL extension f...or DuckDB (run DuckDB in PostgreSQL) Extensions duckdb-ui : web UI for DuckDB Core extension repositories are linked in the Official Extensions page Community... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
- Tableau – A Data Visualization Tool 8226
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...s/ . Windows: Copy it to C:\Program Files\Tableau\Drivers . Linux: Copy it to /opt/tableau/tableau_driver/jdbc . Using the PostgreSQL Dialect If you just want to do something simple, you can try connecting directly to the JDBC driver and using the Tableau-...provided PostgreSQL dialect. Create a DuckDB file containing your views and/or data. Launch Tableau. Under Connect > To a Server > More…, clic...up the connection dialog box. For the URL, enter jdbc:duckdb:/User/username/path/to/database.db . For the Dialect, choose PostgreSQL. The rest of the fields can be ignored: However, functionality will be missing such as median and percentile aggregate fun... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Pattern Matching 8182
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...$'; -- true There are also alternative characters that can be used as keywords in place of LIKE expressions. These enhance PostgreSQL compatibility. PostgreSQL-style LIKE -style ~~ LIKE !~~ NOT LIKE ~~* ILIKE !~~* NOT ILIKE SIMILAR TO The SIMILAR TO operat...SIMILAR TO '.*(b|d).*'; -- true SELECT 'abc' SIMILAR TO '(b|c).*'; -- false SELECT 'abc' NOT SIMILAR TO 'abc'; -- false In PostgreSQL, the ~ and !~ operators perform POSIX regular expression matching, not SIMILAR TO matching. DuckDB follows the same partia...l-matching semantics by default, see the PostgreSQL compatibility page . Globbing DuckDB supports file name expansion, also known as globbing, for discovering files. DuckDB's... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Overview 7830
- DuckDB's SQL dialect is based on PostgreSQL. DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior. For example, interchangeability with data frame libraries necessitates order pre
... - https://man.mtool.work/duckdb/2.0/sql/dialect/overview.html
DuckDB 2.0 Documentation / man.mtool.work