Export csv file to seed postgres table in different environments
up vote
0
down vote
favorite
I want to export a .csv file to seed a table via postgres. I am aware of the copy command and it works fine when the .csv file is a local path.
COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER
Where can I store the .csv file in different environments that aren't local? For example, when I run the seed migration in production, where exactly is it going to get the .csv file to seed the tables in prod?
postgresql csv database-migration
asked Nov 9 at 18:49
patrickhuang94
71611230
add a comment |
up vote
0
down vote
favorite
I want to export a .csv file to seed a table via postgres. I am aware of the copy command and it works fine when the .csv file is a local path.
COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER
Where can I store the .csv file in different environments that aren't local? For example, when I run the seed migration in production, where exactly is it going to get the .csv file to seed the tables in prod?
postgresql csv database-migration
asked Nov 9 at 18:49
patrickhuang94
71611230
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I want to export a .csv file to seed a table via postgres. I am aware of the copy command and it works fine when the .csv file is a local path.
COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER
Where can I store the .csv file in different environments that aren't local? For example, when I run the seed migration in production, where exactly is it going to get the .csv file to seed the tables in prod?
postgresql csv database-migration
asked Nov 9 at 18:49
patrickhuang94
71611230
I want to export a .csv file to seed a table via postgres. I am aware of the copy command and it works fine when the .csv file is a local path.
COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER
Where can I store the .csv file in different environments that aren't local? For example, when I run the seed migration in production, where exactly is it going to get the .csv file to seed the tables in prod?
postgresql csv database-migration
postgresql csv database-migration
asked Nov 9 at 18:49
patrickhuang94
71611230
asked Nov 9 at 18:49
patrickhuang94
71611230
asked Nov 9 at 18:49
patrickhuang94
71611230
asked Nov 9 at 18:49
patrickhuang94
71611230
asked Nov 9 at 18:49
patrickhuang94
71611230
71611230
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You have options, but they all boil down to copying from stdin.
You can pipe the CSV into the psql client.
cat dump.csv | psql -c 'COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER'
Or you can use copy ... from stdin inside psql.
Or you can use the pg_restore tool which basically does the same thing, but is nicer to use, and has lots of options.
answered Nov 9 at 19:16
Schwern
87.5k16100226
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You have options, but they all boil down to copying from stdin.
You can pipe the CSV into the psql client.
cat dump.csv | psql -c 'COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER'
Or you can use copy ... from stdin inside psql.
Or you can use the pg_restore tool which basically does the same thing, but is nicer to use, and has lots of options.
answered Nov 9 at 19:16
Schwern
87.5k16100226
add a comment |
up vote
0
down vote
You have options, but they all boil down to copying from stdin.
You can pipe the CSV into the psql client.
cat dump.csv | psql -c 'COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER'
Or you can use copy ... from stdin inside psql.
Or you can use the pg_restore tool which basically does the same thing, but is nicer to use, and has lots of options.
answered Nov 9 at 19:16
Schwern
87.5k16100226
add a comment |
up vote
0
down vote
up vote
0
down vote
You have options, but they all boil down to copying from stdin.
You can pipe the CSV into the psql client.
cat dump.csv | psql -c 'COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER'
Or you can use copy ... from stdin inside psql.
Or you can use the pg_restore tool which basically does the same thing, but is nicer to use, and has lots of options.
answered Nov 9 at 19:16
Schwern
87.5k16100226
You have options, but they all boil down to copying from stdin.
You can pipe the CSV into the psql client.
cat dump.csv | psql -c 'COPY table_name FROM '/path/to/file.csv' DELIMITER ';' CSV HEADER'
Or you can use copy ... from stdin inside psql.
Or you can use the pg_restore tool which basically does the same thing, but is nicer to use, and has lots of options.
answered Nov 9 at 19:16
Schwern
87.5k16100226
answered Nov 9 at 19:16
Schwern
87.5k16100226
answered Nov 9 at 19:16
Schwern
87.5k16100226
answered Nov 9 at 19:16
Schwern
87.5k16100226
87.5k16100226
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53231704%2fexport-csv-file-to-seed-postgres-table-in-different-environments%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
