Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? I'm not familiar with the Windows version, but the psql.exe file should be with al

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: I converted your HTML message to plain text for you. > Where does the directory lie for psql (so I can put a .sql file in > there and run it) for windows? thanks. It's in the bin directory underneath wherever you install PostgreSQL. But you don't need to put your .sql scri

Re: [GENERAL] Connect to a database in a .sql file

On Tue, 2005-11-08 at 07:31, Assad Jarrahian wrote: > Hi, > Lets say the script is called myDBSetup.sql > > And the script contains: > > //CREATE DATABASE section > //CREATE USERS SECTION > //COnnect to db > //CREATE TABLES, FUNCTIONS etc. > > this script will be called from psql. The user w

Re: [GENERAL] Connect to a database in a .sql file

Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? thanks. -assad On 11/8/05, Richard Huxton wrote: Assad Jarrahian wrote:> Sorry, I am a li

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Nope - psql is psql, pgadmin is pgadmin. All the backslash commands are psql-only rather than being part of the backend. Of course, pgadmin can duplicat

Re: [GENERAL] Connect to a database in a .sql file

Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Just ran the script in psql on my linux box and it worked. My apologies.    Tom, I am not leaping to silly conclusions. Calm down please. We are all trying to learn from people wit

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: \c does not work in .sql script run in psql. That sounds unlikely. What sort of error message are you getting? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please s

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian <[EMAIL PROTECTED]> writes: > \c does not work in .sql script run in psql. Nonsense. Try it again, and show us exactly what you did and what message you got, rather than leaping to silly conclusions. regards, tom lane ---(end of br

Re: [GENERAL] Connect to a database in a .sql file

Hi,     Lets say the script is called myDBSetup.sql And the script contains: //CREATE DATABASE section //CREATE USERS SECTION //COnnect to db //CREATE TABLES, FUNCTIONS etc. this script will be called from psql. The user will log connect to template1 and then run my script. What I really need is

Re: [GENERAL] Connect to a database in a .sql file

On Sun, 6 Nov 2005 18:06:11 -0700, Assad Jarrahian <[EMAIL PROTECTED]> wrote: > Hi, > I am writing a .sql file to create a database, connect to it and create > tables etc. (basic db setup). > But I cannot figure out how to connect to the server (what statement) in a > .sql file. > > any help would