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).

Code: Select all

/i filename
You may also want to look at phppgadmin http://phppgadmin.sourceforge.net/
if you do not already have it.