Hi,

I'm using the libpqxx library and im doing fine but one thing i can't  
figure it out how it should work.
I need to get table information. To MySQL i can simply use the following  
Syntax: 'DESC <tablename>'
So to PostgreSQL i use an escape command like this: '\d "<tablename>"'
Now i thought simply use this command in the transaction.exec() function.  
But i get a Syntax-Error.
I tried with objects 'transaction<>' and 'nontransaction' but its the same  
result.

Anybody knows how I can solve this with libpqxx? Here is my code:

        try
        {
                transaction<> Xaction(m_Connection, "GetDynFields");
                // describe table "POS_DynData"
                result R(Xaction.exec("\\d \"POS_DynData\""));
                Xaction.commit();
        }
        catch (const exception &e)
        {
                // here it always end it with a Syntax-Error at or near "\" at 
character  
1
                return FALSE;
        }
        catch (...)
        {
                return FALSE;
        }


please help me

Lamdacore
_______________________________________________
Libpqxx-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/libpqxx-general

Reply via email to