dbschema 0.1.0

Define database schema's as HCL files, and generate idempotent SQL migrations
Documentation 
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

# Foreign Table

Defines a foreign table linked to a foreign server.

```hcl
foreign_table "remote" {
  schema = "public"
  server = "my_srv"
  column "id" { type = "int", nullable = false }
  options = ["schema_name 'public'", "table_name 'remote_table'"]
}
```

## Attributes
- `name` (label): table name.
- `schema` (string, optional): schema for the table. Defaults to `public`.
- `server` (string): foreign server name.
- `column` blocks: column definitions (`type`, `nullable`, optional `default`, `db_type`, `lint_ignore`, `comment`).
- `options` (array of strings, optional): additional `OPTIONS` entries.
- `comment` (string, optional): documentation comment.

## Examples

```hcl
foreign_table "rt" {
  server = "csv_srv"
  column "id" { type = "int", nullable = false }
  options = ["filename '/tmp/data.csv'"]
}
```