Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Scripts for importing the USDA Nutrient Database (SR28) into a PostgreSQL database

NotificationsYou must be signed in to change notification settings

Adyg/usdanl-sr28-postgresql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Script for importing the USDA Nutrients Database into PostgreSQL.

  1. Downloads & unzips the USDA Nutrients Database in .txt format
  2. Creates the PostgreSQL tables
  3. Imports the data from the unzipped .txt files

Usage

  1. Create a PostgreSQL database, UTF-8 encoded.
  2. Run./import_usdand.sh postgresDatabase

Misc

An Ansible powered Vagrant box is also included, it reflects the environment this was built and used in.

If you just want the PostgreSQL database without having to run the script, a pg_dump can be found in usda_sr28.sql

About

Scripts for importing the USDA Nutrient Database (SR28) into a PostgreSQL database

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

[8]ページ先頭
©2009-2025 Movatter.jp