Re: 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 <dev(at)archonet(dot)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
>