Results of 1 - 10 of about 38 for Schemas (0.002 sec.)
- CREATE SCHEMA Statement 15063
- The CREATE SCHEMA statement creates a schema in the catalog. The default schema is main . Examples Create a schema: CREATE SCHEMA s1; Create a schema if it does not exist yet: CREATE SCHEMA IF NOT EXISTS s2; Create a schema or replace a sch
...ema if it exists: CREATE OR REPLACE SCHEMA s2; Create table in the schemas: CREATE TABLE s1.t (id INTEGER PRIMARY KEY, other_id INTEGER); CREATE TABLE s2.t (id INTEGE...R PRIMARY KEY, j VARCHAR); Compute a join between tables from two schemas: SELECT * FROM s1.t s1t, s2.t s2t WHERE s1t.other_id = s2t.id; Nested Schemas New Support for nested schemas was introduce...d in DuckDB 2.0. Schemas can be nested within other schemas. Objects in a nested schema are referenced using their fully qualified, dot-separated p... - https://man.mtool.work/duckdb/2.0/sql/statements/create_schema.html
- SHOW, SHOW DATABASES, and SHOW SCHEMAS Statements 11415
- SHOW Statement The SHOW statement can also show the schema of a table, view or query, like DESCRIBE . As of DuckDB 2.0, this usage is deprecated and prints a warning; use DESCRIBE instead. New The following feature was introduced in DuckDB
...y_database; SHOW DATABASES; database_name memory my_database DETACH my_database; SHOW DATABASES; database_name memory SHOW SCHEMAS Statement This statement was introduced in DuckDB 1.5. The SHOW SCHEMAS statement shows a list of all schemas across non-i...nternal databases: SHOW SCHEMAS; database_name schema_name current memory main true The current column indicates which schema is the default schema (set v... - https://man.mtool.work/duckdb/2.0/sql/statements/show.html
- Combining Schemas 9906
- Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When
...reading from multiple files, we have to combine schemas from those files. That is because each file has its own schema that can differ from the other files. DuckDB offers two way...s of unifying schemas of multiple files: by column position and by column name . By default, DuckDB reads the schema of the first file provided,...This is equivalent to the SQL construct UNION ALL . Union by Name If you are processing multiple files that have different schemas, perhaps because columns have been added or renamed, it might be desirable to unify the columns of different files by name... - https://man.mtool.work/duckdb/2.0/data/multiple_files/combining_schemas.html
- Reading Multiple Files 9906
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different schemas
...sv : SELECT * FROM read_csv(['flights1.csv', 'flights2.csv']); Read the CSV files flights1.csv and flights2.csv , unifying schemas by name and outputting a filename column: SELECT * FROM read_csv(['flights1.csv', 'flights2.csv'], union_by_name = true, f...ames explicitly. If the directory contains no matching files, the query raises an error. Directory paths do not change how schemas are combined. When files have different columns, use union_by_name = true as described in combining schemas . List Paramet... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Information Schema 9497
- 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
...a : Database, Catalog and Schema The top level catalog view is information_schema.schemata . It lists the catalogs and the schemas present in the database and has the following layout: Column Description Type Example catalog_name Name of the database th...of constraints. VARCHAR 'YES' Catalog Functions Several functions are also provided to see details about the catalogs and schemas that are configured in the database. Function Description Example Result current_catalog() Return the name of the currentl...'memory' current_schema() Return the name of the currently active schema. Default is main. current_schema() 'main' current_schemas(boolean) Return list of schemas. Pass a parameter of true to include implicit schemas. current_schemas(true) ['main', 'mai... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Utility Functions 8789
- Scalar 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) Whet
...the current query as a UBIGINT . current_schema() Return the name of the currently active schema. Default is main. current_schemas(boolean) Return list of schemas. Pass a parameter of true to include implicit schemas. current_setting('setting_name') Ret...eturn the name of the currently active schema. Default is main. | | Example | current_schema() | | Result | main | current_schemas(boolean) | Description | Return list of schemas. Pass a parameter of true to include implicit schemas. | | Example | curre...nt_schemas(true) | | Result | ['temp', 'main', 'pg_catalog'] | current_setting('setting_name') | Description | Return the current val... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- DuckDB Environment 8679
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...DuckDB's keywords and reserved words duckdb_optimizers() : the available optimization rules in the DuckDB instance duckdb_schemas() : schemas duckdb_sequences() : sequences duckdb_settings() : settings duckdb_tables() : base tables duckdb_temporary_fil... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Friendly SQL 8270
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...VARIABLE The $name shorthand for reading variables : write $x instead of getvariable('x') . Organizing the catalog: Nested schemas : create schemas within schemas, e.g., CREATE SCHEMA finance.reports . Managing extensions and settings: INSTALL AND LOAD... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Configuration 7972
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...Schema and Search Path The schema and search_path configuration options both control the search path : the ordered list of schemas that DuckDB consults to resolve unqualified table, view, and function names. Despite the difference in their descriptions,...ecific database; an unqualified entry refers to a schema in the current catalog. This is why the descriptions mention both schemas and catalogs: the path is a list of schemas, whose entries may optionally be catalog-qualified. Asynchronous I/O Settings...s Whether the external file cache also caches local files. Remote files are always cached. BOOLEAN false catalog_error_max_schemas The maximum number of schemas in the catalog that the system will scan to generate the "did you mean..." error message. UB... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Pragmas 7972
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...rly to DESCRIBE : PRAGMA show_tables_expanded; To list all functions: PRAGMA functions; For queries targeting non-existing schemas, DuckDB generates “did you mean...” style error messages. When there are thousands of attached databases, these errors can...take a long time to generate. To limit the number of schemas DuckDB looks through, use the catalog_error_max_schemas option: SET catalog_error_max_schemas = 10; Table Information Get... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
DuckDB 2.0 Documentation / man.mtool.work