[GH-ISSUE #39] Import and outport csv data #36

Open
opened 2026-02-27 23:18:35 +03:00 by kerem · 4 comments
Owner

Originally created by @alansmitheejp on GitHub (Jan 30, 2019).
Original GitHub issue: https://github.com/snibox/snibox/issues/39

I hope
import snipets data by csv file.
outport snipets data to csv file.
thanks.

Originally created by @alansmitheejp on GitHub (Jan 30, 2019). Original GitHub issue: https://github.com/snibox/snibox/issues/39 I hope import snipets data by csv file. outport snipets data to csv file. thanks.
Author
Owner

@yhdesai commented on GitHub (Feb 15, 2019):

@vavgustov Please make this happen!
I just need a way to backup the data thus it can be restored if there are any issues with the server, Thus the format doesnt matter.

<!-- gh-comment-id:463960724 --> @yhdesai commented on GitHub (Feb 15, 2019): @vavgustov Please make this happen! I just need a way to backup the data thus it can be restored if there are any issues with the server, Thus the format doesnt matter.
Author
Owner

@vavgustov commented on GitHub (Feb 15, 2019):

You can create backups using PostgreSQL commands.

E.g. to export sql dump:

pg_dump snibox_production > snibox_production.sql

More info: https://www.linode.com/docs/databases/postgresql/how-to-back-up-your-postgresql-database/

To export snippets as csv (without label names):

psql
\c snibox_production;
COPY snippets to '/<insert_your_path_here>/snippets.csv' WITH (FORMAT CSV, HEADER);

More info: https://stackoverflow.com/a/1120390

<!-- gh-comment-id:464006729 --> @vavgustov commented on GitHub (Feb 15, 2019): You can create backups using PostgreSQL commands. E.g. to export sql dump: ``` pg_dump snibox_production > snibox_production.sql ``` **More info:** https://www.linode.com/docs/databases/postgresql/how-to-back-up-your-postgresql-database/ To export snippets as csv (without label names): ``` psql \c snibox_production; COPY snippets to '/<insert_your_path_here>/snippets.csv' WITH (FORMAT CSV, HEADER); ``` **More info:** https://stackoverflow.com/a/1120390
Author
Owner

@yhdesai commented on GitHub (Feb 15, 2019):

Thanks for the info!

<!-- gh-comment-id:464008527 --> @yhdesai commented on GitHub (Feb 15, 2019): Thanks for the info!
Author
Owner

@crispybegs commented on GitHub (May 2, 2023):

would also love this, if this project is still even being looked at of course

<!-- gh-comment-id:1531698598 --> @crispybegs commented on GitHub (May 2, 2023): would also love this, if this project is still even being looked at of course
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/snibox#36
No description provided.