[plug] dum syntax Q

[Sol]

Thankyou Tony,

And all it took was double inverted commas....

regards,
sol

> On Fri, 26 Jul 2002, Sol wrote:
> 
> > I'm bashing my head against a wall trying to grant permissions to
the user 'www-data' on a pgsql db because it sees the '-' as a 
> > minus sign. '\' doesn't work as an escape as in BASH. And the online
documentation deals with everything but this syntax nasty.
> > Anyone come across this before?
> 
> tony at tyr:~$ createdb fred
> CREATE DATABASE
> tony at tyr:~$ psql fred
> Welcome to psql, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> fred=# create table fred ( id serial primary key, data varchar(256) );
> NOTICE:  CREATE TABLE will create implicit sequence 'fred_id_seq' for
SERIAL
> column 'fred.id'
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'fred_pkey' for
> table 'fred'
> CREATE
> fred=# grant all on fred to "www-data";
> GRANT
> fred=# \quit
> tony at tyr:~$ dropdb fred
> DROP DATABASE
> tony at tyr:~$
> 
> HTH.
> 
> 
> Yours Tony
> 
>    Jan 22-25 2003           Linux.Conf.AU            http://linux.conf.au/
> 		  The Australian Linux Technical Conference!
> 
> 
>