Page 1 of 1
PostgreSQL: Loading tables from file
Posted: Fri Sep 17, 2004 8:18 pm
by myleow
I have a file call tables.sql that has all my table creation statements in there.
How do i load it into the DB?
Regards
Mian
Posted: Mon Sep 20, 2004 3:36 am
by CoderGoblin
From system prompt....
Code: Select all
cd directory
psql -h <server> <database> <user>
(you can change the directory when you are in the db, but easier outside).
You may also want to look at phppgadmin
http://phppgadmin.sourceforge.net/
if you do not already have it.