GnuCash 2.3.x/2.4 PostgreSQL Schema support?
Anthony Messina
amessina at messinet.com
Sat Jun 5 11:07:57 EDT 2010
On Tuesday, June 01, 2010 07:55:39 pm Vinny wrote:
> A relatively elegant way to do this is to set the
> 'search_path' for the database username that you are using.
>
> pgAdmin III allows you to set properties on the login roles.
> If you set the search path, it will find the gnucash schema
> first and use it.
>
> set search_path to gnucash,public;
>
> New tables will be created in the gnucash schema.
> Searches for tables (for SQL statements that don't
> specify a table's schema using the dot operator),
> will start in the gnucash schema and proceed to the
> public schema, until the table is found.
>
> Regards,
> Vinny
This looks interesting. I will look into this option. Thank you. -A
--
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100605/66f5e8a9/attachment.bin>
More information about the gnucash-user
mailing list