dolthub / dolthub/doltgresql

`ALTER TABLE` support

Open
#724 0 comments 0 reactions 0 assignees View on GitHub
data import
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 10h
Merged PRs (30d)
129

Description

`ALTER TABLE` is commonly used in import SQL scripts. Adding foreign keys after loading data into tables appears to be one of the more common uses in import scripts.

**Examples:**
* [Chinook_PostgreSql_utf8.sql](https://github.com/morenoh149/postgresDBSamples/blob/master/chinook-1.4/Chinook_PostgreSql_utf8.sql) uses `ALTER TABLE` to add foreign key constraints to created tables after data has been loaded.
* [dellstore2-normal-1.0.sql](https://github.com/morenoh149/postgresDBSamples/blob/master/dellstore2-normal-1.0/dellstore2-normal-1.0.sql) uses `ALTER TABLE` to add primary key constraints as well as foreign key constraints after data has been loaded.

 
**Use cases:**
- [x] Add primary key
- [x] Add foreign key constraint
- [ ] Alter owner

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.