Postgres Pro
Downloads
Home   >   mailing lists

Re: user name doesn't seem to resolve to $user in search_path - Mailing list pgsql-admin

From Tom Lane
Subject Re: user name doesn't seem to resolve to $user in search_path
Date
Msg-id 20267.1066372559@sss.pgh.pa.us
Whole thread Raw
In response to Re: user name doesn't seem to resolve to $user in search_path  (frank.messie@osix.nl)
List pgsql-admin
Tree view 
frank.messie@osix.nl writes:
> SET search_path TO $user
> gives an parsing error caused by the $ sign.

You need quotes around '$user'.

            regards, tom lane

pgsql-admin by date:

Previous
From: frank.messie@osix.nl
Date:
Subject: Re: user name doesn't seem to resolve to $user in search_path
Next
From: "Soeren Laursen"
Date:
Subject: Missing a good db migration/db move tool