File: ForeignSchemaImporting.md

package info (click to toggle)
tds-fdw 2.0.2-2
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, sid
  • size: 936 kB
  • sloc: ansic: 5,201; sql: 496; python: 326; makefile: 23; sh: 1
file content (36 lines) | stat: -rw-r--r-- 616 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# TDS Foreign data wrapper

* **Name:** tds_fdw
* **File:** tds_fdw/ForeignSchemaImporting.md

## Importing a Foreign Schema

### Options

#### Foreign schema parameters accepted:

* *import_default*

Required: No

Default: false

Controls whether column DEFAULT expressions are included in the definitions of foreign tables.

* *import_not_null*

Required: No

Default: true

Controls whether column NOT NULL constraints are included in the definitions of foreign tables.

### Example

```SQL
IMPORT FOREIGN SCHEMA dbo
	EXCEPT (mssql_table)
	FROM SERVER mssql_svr
	INTO public
	OPTIONS (import_default 'true');
```