DK11 for Delphi | GisDbLibpq.TGIS_DbLibpq | Classes | Constructors | Fields | Methods | Properties
Class that can read PostgreSQL.
Available also on: .NET.
// Delphi type TGIS_DbLibpq = class( TGIS_DbAbstract ) end;
// C++ Builder class PASCALIMPLEMENTATION TGIS_DbLibpq : public TGIS_DbAbstract { };
→ TObject → TGIS_ObjectDisposable → TGIS_DbAbstract
Name | Visibility | Description | |
---|---|---|---|
Create | public | Constructor. (Overrides TGIS_DbAbstract.Create) |
|
Name | Visibility | Description | |
---|---|---|---|
FDialect | protected | SQL dialect name. (Inherited from TGIS_DbAbstract) |
|
FFullSafeParam | protected | if True, prefix with name is returned, otherwise only prefix. (Inherited from TGIS_DbAbstract) |
|
FGeometryType | protected | Internal geometry type. (Inherited from TGIS_DbAbstract) |
|
FiCodePage | protected | CodePage stored for optimization purposes. (Inherited from TGIS_DbAbstract) |
|
FiJoinCodePage | protected | JoinCodePage stored for optimization purposes. (Inherited from TGIS_DbAbstract) |
|
FInBatchMode | protected | True, if batch mode is enabled. (Inherited from TGIS_DbAbstract) |
|
FisDb2 | protected | Is DB2 dialect. (Inherited from TGIS_DbAbstract) |
|
FisInformix | protected | Is Informix dialect. (Inherited from TGIS_DbAbstract) |
|
FIsInitializedProvider | protected | Is provider initialized. (Inherited from TGIS_DbAbstract) |
|
FisInterbase | protected | Is Interbase dialect. (Inherited from TGIS_DbAbstract) |
|
FIsJDBC | protected | if True, JDBC is used. (Inherited from TGIS_DbAbstract) |
|
FisMsJet | protected | Is MsJet dialect. (Inherited from TGIS_DbAbstract) |
|
FisMsSql | protected | Is MsSql dialect. (Inherited from TGIS_DbAbstract) |
|
FisMySql | protected | Is MySql dialect. (Inherited from TGIS_DbAbstract) |
|
FisOracle | protected | Is Oracle dialect. (Inherited from TGIS_DbAbstract) |
|
FisPostgreSql | protected | Is PostgreSQL dialect. (Inherited from TGIS_DbAbstract) |
|
FisSqlite | protected | Is Sqlite dialect. (Inherited from TGIS_DbAbstract) |
|
FisSybase | protected | Is Sybase dialect. (Inherited from TGIS_DbAbstract) |
|
FMultiUserMode | protected | MultiUser mode. (Inherited from TGIS_DbAbstract) |
|
FNameMaxLength | protected | Sql name max length. (Inherited from TGIS_DbAbstract) |
|
FOnSQLExecute | protected | SQL execute event handler. (Inherited from TGIS_DbAbstract) |
|
FParameterPrefix | protected | Sql parameter prefix. (Inherited from TGIS_DbAbstract) |
|
FRowsetSize | protected | Number of rows fetched in batches from the cursor database (default 0). (Inherited from TGIS_DbAbstract) |
|
FUseTextParameters | protected | Use text parameters. (Inherited from TGIS_DbAbstract) |
|
options | protected | Engine options. (Inherited from TGIS_DbAbstract) |
|
Name | Visibility | Description | |
---|---|---|---|
cursorClose | public | Free cursor allocated by CursorOpen(). (Overrides TGIS_DbAbstract.cursorClose) |
|
cursorOpen | public | Allocate new cursor. (Overrides TGIS_DbAbstract.cursorOpen) |
|
FinalizeProvider | public | Finalize provider. (Overrides TGIS_DbAbstract.FinalizeProvider) |
|
getLastCursor | public | Get last opened cursor index. (Overrides TGIS_DbAbstract.getLastCursor) |
|
GetLastErrorMessage | public | Return last error message text. (Overrides TGIS_DbAbstract.GetLastErrorMessage) |
|
InitializeProvider | public | Initialize provider. (Overrides TGIS_DbAbstract.InitializeProvider) |
|
PreRecognize | public | Check if layer can read a file. (Inherited from TGIS_DbAbstract) |
|
safeParam | public | Get a safe parameter. (Inherited from TGIS_DbAbstract) |
|
sqlBaseFolder | public | Return base folder for a layer. (Inherited from TGIS_DbAbstract) |
|
sqlBindField | public | Obtain a bind number for a given field name. (Overrides TGIS_DbAbstract.sqlBindField) |
|
sqlBuild | public | Build new SQL layer. (Overrides TGIS_DbAbstract.sqlBuild) |
|
sqlConnect | public | Open database connection. (Overrides TGIS_DbAbstract.sqlConnect) |
|
sqlCreateFunction | public | Create a function on database site. (Inherited from TGIS_DbAbstract) |
|
sqlDisconnect | public | Close database connection. (Overrides TGIS_DbAbstract.sqlDisconnect) |
|
sqlExec | public | Execute a command. (Overrides TGIS_DbAbstract.sqlExec) |
|
sqlGetBindedField | public | Get the field value for a shape given by a unique identity. (Overrides TGIS_DbAbstract.sqlGetBindedField) |
|
sqlGetParams | public | Get parameters list. (Overrides TGIS_DbAbstract.sqlGetParams) |
|
sqlInitialize | public | Initialize database flags and options. (Inherited from TGIS_DbAbstract) |
|
sqlLastInsertId | public | Get last inserted record id. (Inherited from TGIS_DbAbstract) |
|
sqlPathAbsolute | public | Resolves potentially emebeded database path in a connection string into an abolute path. (Inherited from TGIS_DbAbstract) |
|
sqlQueryClose | public | Close the query. (Overrides TGIS_DbAbstract.sqlQueryClose) |
|
sqlQueryEof | public | Test for Eof on query. (Overrides TGIS_DbAbstract.sqlQueryEof) |
|
sqlQueryGeometryIsText | public | Is geometry data a text. (Overrides TGIS_DbAbstract.sqlQueryGeometryIsText) |
|
sqlQueryGetBlob | public | Get blob data type. (Overrides TGIS_DbAbstract.sqlQueryGetBlob) |
|
sqlQueryGetField | public | Get a field from the query by field name. (Overrides TGIS_DbAbstract.sqlQueryGetField) |
|
sqlQueryGetFieldById | public | Get a field from the query by field id. (Overrides TGIS_DbAbstract.sqlQueryGetFieldById) |
|
sqlQueryGetFieldIndex | public | Get field index from query. (Overrides TGIS_DbAbstract.sqlQueryGetFieldIndex) |
|
sqlQueryGetGeomObj | public | Get a geometry object from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomObj) |
|
sqlQueryGetGeomPtr | public | Get a geometry from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomPtr) |
|
sqlQueryGetGeomVAR | public | Get a geometry from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomVAR) |
|
sqlQueryGetGEOUID(Integer; Integer) | public | Get a GEO.UID from the query. | |
sqlQueryGetGEOUID(String; Integer) | public | Get a GEO.UID from the query. | |
sqlQueryGetSHAPETYPE | public | Get a SHAPETYE from the query. (Overrides TGIS_DbAbstract.sqlQueryGetSHAPETYPE) |
|
sqlQueryGetXMIN | public | Get a XMIN from the query. (Overrides TGIS_DbAbstract.sqlQueryGetXMIN) |
|
sqlQueryGetYMIN | public | Get a YMIN from the query. (Overrides TGIS_DbAbstract.sqlQueryGetYMIN) |
|
sqlQueryMoveFirst | public | Move to first record of query. (Overrides TGIS_DbAbstract.sqlQueryMoveFirst) |
|
sqlQueryMoveNext | public | Move to next record of query. (Overrides TGIS_DbAbstract.sqlQueryMoveNext) |
|
sqlQueryNameGEOUID | public | Get a GEO.UID field from the query. (Overrides TGIS_DbAbstract.sqlQueryNameGEOUID) |
|
sqlQueryOpen | public | Open the query. (Overrides TGIS_DbAbstract.sqlQueryOpen) |
|
sqlQueryReset | public | Reset current sql query. (Overrides TGIS_DbAbstract.sqlQueryReset) |
|
sqlQueryStructure | public | Fill the current layer structure based on the query. (Overrides TGIS_DbAbstract.sqlQueryStructure) |
|
sqlQueryUnPrepareGetGeom | public | Unprepare geometry access. (Overrides TGIS_DbAbstract.sqlQueryUnPrepareGetGeom) |
|
sqlTableAppend | public | Append a new record into the table. (Overrides TGIS_DbAbstract.sqlTableAppend) |
|
sqlTableClose | public | Close the table. (Overrides TGIS_DbAbstract.sqlTableClose) |
|
sqlTableCreateParam | public | Create a table parameter. (Overrides TGIS_DbAbstract.sqlTableCreateParam) |
|
sqlTableEof | public | Test for Eof on the table. (Overrides TGIS_DbAbstract.sqlTableEof) |
|
sqlTableExec | public | Execute opened table command. (Overrides TGIS_DbAbstract.sqlTableExec) |
|
sqlTableGetField | public | Get a field from the table. (Overrides TGIS_DbAbstract.sqlTableGetField) |
|
sqlTableGetFieldIndex | public | ||
sqlTableGetParam | public | Get a parameter from the table. (Overrides TGIS_DbAbstract.sqlTableGetParam) |
|
sqlTableOpenRead | public | Open the table based on provided filter. (Overrides TGIS_DbAbstract.sqlTableOpenRead) |
|
sqlTableOpenWrite | public | Open the table based on provided filter (Overrides TGIS_DbAbstract.sqlTableOpenWrite) |
|
sqlTablePost | public | Update the table (after any change). (Overrides TGIS_DbAbstract.sqlTablePost) |
|
sqlTablePrepare | public | ||
sqlTablePrepared | public | Is table prepared for insert. (Overrides TGIS_DbAbstract.sqlTablePrepared) |
|
sqlTableSetBlob | public | Set a blob data to the table. (Overrides TGIS_DbAbstract.sqlTableSetBlob) |
|
sqlTableSetField | public | Set a field to the table. (Overrides TGIS_DbAbstract.sqlTableSetField) |
|
sqlTableSetGeometry(Integer; String; OleVariant; TGIS_MemoryStream) | public | Set a geometry to the table. | |
sqlTableSetGeometry(Integer; String; TObject) | public | Set a geometry to the table. | |
sqlTransactGlobalUpdateCommit | public | Commit global transaction. (Overrides TGIS_DbAbstract.sqlTransactGlobalUpdateCommit) |
|
sqlTransactGlobalUpdateStart | public | Start global transaction. (Overrides TGIS_DbAbstract.sqlTransactGlobalUpdateStart) |
|
sqlTransactRestructCommit | public | Commit transaction. (Overrides TGIS_DbAbstract.sqlTransactRestructCommit) |
|
sqlTransactRestructStart | public | Start transaction. (Overrides TGIS_DbAbstract.sqlTransactRestructStart) |
|
sqlTransactRollback | public | Rollback global transaction. (Overrides TGIS_DbAbstract.sqlTransactRollback) |
|
sqlTransactUpdateCommit | public | Commit transaction. (Overrides TGIS_DbAbstract.sqlTransactUpdateCommit) |
|
sqlTransactUpdateStart | public | Start transaction. (Overrides TGIS_DbAbstract.sqlTransactUpdateStart) |
|
sqlUpdateStart | public | Macro for starting updates. (Overrides TGIS_DbAbstract.sqlUpdateStart) |
|
Name | Visibility | Description | |
---|---|---|---|
CurrentSQLDialect | public | Current SQL dialect name. (Inherited from TGIS_DbAbstract) |
|
EngineOptions | public | Engine options. (Inherited from TGIS_DbAbstract) |
|
FullSafeParam | public | if True, prefix with name is returned, otherwise only prefix. (Inherited from TGIS_DbAbstract) |
|
GeometryType | public | Internal geometry type. (Inherited from TGIS_DbAbstract) |
|
iCodePage | public | CodePage used for conversion. (Inherited from TGIS_DbAbstract) |
|
iJoinCodePage | public | JoinCodePage used for conversion. (Inherited from TGIS_DbAbstract) |
|
InBatchMode | public | True, if batch mode is enabled for fast inserts. (Inherited from TGIS_DbAbstract) |
|
IsDb2 | public | Is DB2 dialect. (Inherited from TGIS_DbAbstract) |
|
IsInformix | public | Is Informix dialect. (Inherited from TGIS_DbAbstract) |
|
IsInterbase | public | Is Interbase dialect. (Inherited from TGIS_DbAbstract) |
|
IsJDBC | public | if True, JDBC is used. (Inherited from TGIS_DbAbstract) |
|
IsMsJet | public | Is MsJet dialect. (Inherited from TGIS_DbAbstract) |
|
IsMsSql | public | Is MsSql dialect. (Inherited from TGIS_DbAbstract) |
|
IsMySql | public | Is MySql dialect. (Inherited from TGIS_DbAbstract) |
|
IsOracle | public | Is Oracle dialect. (Inherited from TGIS_DbAbstract) |
|
IsPostgreSql | public | Is PostgreSQL dialect. (Inherited from TGIS_DbAbstract) |
|
IsProviderInitialized | public | Is provider initialized. (Inherited from TGIS_DbAbstract) |
|
IsSqlite | public | Is Sqlite dialect. (Inherited from TGIS_DbAbstract) |
|
IsSybase | public | Is Sybase dialect. (Inherited from TGIS_DbAbstract) |
|
MultiUserMode | public | Multiuser mode. (Inherited from TGIS_DbAbstract) |
|
NameMaxLength | public | Sql name maximum length. (Inherited from TGIS_DbAbstract) |
|
ParameterPrefix | public | Sql parameter prefix. (Inherited from TGIS_DbAbstract) |
|
RowsetSize | public | Number of rows fetched in batches from the cursor database (default 0). (Inherited from TGIS_DbAbstract) |
|
UseTextParameters | public | Use text parameters. (Inherited from TGIS_DbAbstract) |
|