Re: Using sql statements in file

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Suresh Basandra <sureshb(at)warpera(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using sql statements in file
Date: 2003-09-23 05:22:24
Message-ID: Pine.LNX.4.44.0309231049100.1385-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2003-09-23 05:38:48 Re: GiST and full text search
Previous Message Joe Conway 2003-09-23 03:59:27 Re: Oracle 'connect by prior' now eaiser in 7.3?