Many Thanks!!! It works! Regards,
Josef 2011/10/10 Ondrej Ivanič <ondrej.iva...@gmail.com>: > Hi, > > On 10 October 2011 21:35, József Kurucz <jozsef.kur...@invitel.hu> wrote: >> ERROR: syntax error at or near "$1" >> LINE 1: create table $1 ( ) >> ^ >> QUERY: create table $1 ( ) >> CONTEXT: SQL statement in PL/PgSQL function "check_table" near line 22 > > I think you have to use "execute": > > execute 'create table ' || tblname || ' ()'; > > http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN > > -- > Ondrej Ivanic > (ondrej.iva...@gmail.com) > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
