| sqlayinpgsql(1) | SqLay Suite | sqlayinpgsql(1) |
sqlayinpgsql - a PostgreSQL database driver for sqlay.
libsqlayinpgsql.so
[sqlaytool] [options] pgsql:datasource
sqlayinpgsql is the PostgreSQL driver for sqlay. It supports DML read-write and DDL. It interpretes a datasource feeded in the form of a pgsql: URL allowing to connect to a PostgreSQL server.
It has been initially developped with PostgreSQL 7.3.2, is tested mainly with 7.3.4, but is known to work, at least partially with PostgreSQL from 7.0.3.
The driver is loaded by giving as argument to the sqlaytool front-end executable a pgsql: URL.
The pgsql: prefix could be replaced by a colon alone (:) if the tool has been compiled with this driver as default driver or if it is the current value of the environment variable SQLAYDRIVER.
Alternatively, the pgsql proto name can be replaced by one of the following aliases: postgres or postgresql.
System tables are skipped by default but can be explicitely asked for in the sqlds tools and viewed in the sqlsc tools by using pg_ as table name pattern.
The driver detects tables names and comments, view (detected as tables in 7.0.x) names and comments, field names and comments, commonly used datatypes with their length and precision, null and not null flags, default values with most obvious highlighting, unique and non-unique indexes, primary and foreign keys, a count of data by table or view, grants on tables and views.
As other input drivers for sqlay, the only connection available for now is a shared connection.
Pls understand that this is an alpha release and none of the executables is securized against buffer overflows, and so on. It is also not thread safe.
See the NOTE above for important security warnings.
E. Lurquin <sqlay@hitud.net>
sqlayin(1), sqlay(1), sqlsc(1), sqlds(1), psql(1)
| sqlayinpgsql 0.8 | Dec 2008 | sqlayinpgsql(1) |