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
PostgreSQL: Loading tables from file
Moderator: General Moderators
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
From system prompt....
(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.
Code: Select all
cd directory
psql -h <server> <database> <user>Code: Select all
/i filenameif you do not already have it.