> 1. put create database, create tables sql statements in a file and > execute through prompt > 2. insert or update data that is put in a file
Place your commands in a file & execute them either from the prompt or from psql. Remember to create your file in the below order: 1) create database 2) connect to new database (\c) 3) create tables/views/functions ... 4) insert/update commands regards, bhuvaneswaran ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
