Re: Using sql statements in file - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: Using sql statements in file
Date
Msg-id Pine.LNX.4.44.0309231049100.1385-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Using sql statements in file  ("Suresh Basandra" <sureshb@warpera.com>)
List 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




pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
Next
From: Oleg Bartunov
Date:
Subject: Re: GiST and full text search