search

zipperer / migrate_database_with_michael

0 stars 0 forks source link

Create table in postgres #21

Closed zipperer closed 7 months ago

zipperer commented 7 months ago

Follow steps from postgres_script.txt

== create table in postgres ==
psql> CREATE TABLE my_table();
psql> \d
psql> \d my_table
psql> ALTER TABLE my_table ADD COLUMN name VARCHAR UNIQUE NOT NULL;
psql> \d my_table
psql> SELECT * FROM my_table;
psql> SELECT name FROM my_table;
zipperer commented 7 months ago

We did this during #2 .