Re: [GENERAL] SHOW

2001-09-04 Thread Stephan Bergmann
Hi Joe. > > Start up psql with the -E on the command line. Then do \d TABLE. This will > show you the actual SQL commands used by psql. Doesn't change nothing. > See the psql man page for more details. No hints to find there respective to the libpq's PQexec. Greetings Steve ---

Re: [GENERAL] SHOW

2001-09-03 Thread Stephan Bergmann
Hi! > > > What is the equivalent to the mysql's: > > SHOW COLUMNS FROM [TABLENAME]; > > in psql, \d will show you all tables and \d TABLE will show you the > columns in the table. If you need it as a sql command, you can check the > system tables. OK. That works for ./bin/psql, but NOT on th

[GENERAL] C API

2001-08-28 Thread Stephan Bergmann
Hi List! I'm using the libpq C library and I'm looking for a C function, that returns me the version (e.g. 7.1.3) of the backend server I'm conected to! Some's any idea? Thanx and greetings Steve ---(end of broadcast)--- TIP 4: Don't 'kill -9' t

[GENERAL] libpq

2001-08-24 Thread Stephan Bergmann
Hi! Compiling the following returns me - executing the result.cgi - the error: ./result.cgi: can't load library 'libpq.so.2' gcc -lpq -I/usr/include/mysql -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -L/usr/lib/mysql program.c -o result.cgi -Wall -DUNIX -lmysqlclient -lm All files are at i