Hi,
On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar wrote:
> create set (id=2, origin=1, comment='All tables');
>
> but it gives error
>
> syntax error near unexpected token `('
That command must be passed to slonik, not to bash.
Here is an example:
#!/bin/bash
slonik << _END_
cluster name = testcluster;
node 1 admin conninfo = 'dbname=test1 host=192.168.2.3 port=5432
user=postgres';
node 2 admin conninfo = 'dbname=test2 host=192.168.2.4 port=5432
user=postgres';
create set (id=1, origin=1, comment='test tables');
echo 'Set created';
set add table (set id=1, origin=1, id=1, full qualified name =
'public.test_table', comment='test table');
_END_
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/