Re: Connect to a database in a .sql file - Mailing list pgsql-general

From Assad Jarrahian
Subject Re: Connect to a database in a .sql file
Date
Msg-id 4bd3e1480511081025x7e8acd8dg7ff8b5c95d22f363@mail.gmail.com
Whole thread Raw
In response to Re: Connect to a database in a .sql file  (Richard Huxton <dev@archonet.com>)
Responses Re: Connect to a database in a .sql file  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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 <dev@archonet.com> wrote:
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
duplicate them if they want.

> Just ran the script in psql
> on my linux box and it worked.

And on Windows too. Not sure if you need to change the line-endings though.

> My apologies.
> Tom, I am not leaping to silly conclusions. Calm down please. We are all
> trying to learn from people with knowledge. Be curtious.

The problem is Assad that your email saying \c doesn't work in psql is
now in the archive forever. In a couple of days Google will index it and
then the world at large will be coming across it. And it's not worded as
a question "I can't get \c to work in psql" - just says it doesn't work,
so it might be that a questioner doesn't look any further, assuming you
were right.

It's not the leaping to a conclusion that's done the damage, and it's
not the instant archiving, but the combination of the two.

Of course Tom could have been a little more gentle in his dressing down,
but since I'd guess he's been working pretty hard recently getting 8.1
out of the door (released today!) I'm prepared to cut him some slack.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Programmatic method to determine currently installed Windows PostrgreSQL version
Next
From: Joe Lester
Date:
Subject: Re: Detect Locked Row Without Blocking