>>>> Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:50 >>> >>> To see how e.g. \dC etc work start psql with -E >>> >> I'm sorry, but I don't have commandline access to the database. That would >> require an amount of trust and a level of competence our ICT department is >> incapable of. > >Well, if you have access to prt 5432 (or whatever you are using) on the >DB host you can run psql locally: psql -h <db-hostname> All I have is my desktop Windows pc. I work on the database using EMS SQL Manager for PostgreSQL. There I can run whatever statement I want, but it's not psql. What do you exactly mean with "run psql locally"? Should I be able to run some psql.exe from my windows cmd environment. Or should I start something else first?
>As a last resort you can always see how they work on a local copy, then >cut + paste the SQL. Here too, I don't know what you mean exactly with "a local copy".