postgresql howto 12 mz3vntmiyza2ob7rqi4g2bh2j7gog3ykasqkeqy MZ3VNTMIYZA2OB7RQI4G2BH2J7GOG3YKASQKEQY


Database-SQL-RDBMS HOW-TO document for Linux (PostgreSQL Object Relational Database System): PostgreSQL Management Tools 12. PostgreSQL Management Tools12.1 PGACCESS - A GUI Tool for PostgreSQL ManagementPgAccess is a Tcl/Tk interface to PostgreSQL. It is already included in the distribution of PostgreSQL. You may want to check out this web site for a newer copyhttp://www.flex.ro/pgaccessIf you have any comment, suggestion for improvements, please feel free to e-mail to : teo@flex.roFeatures of PgAccessPgAccess windows - Main window, Table builder, Table(query) view, Visual query builder.Tablesopening tables for viewing, max 200 records (changed by preferences menu)column resizing, dragging the vertical grid line (better in table space rather than in the table header)text wrap in cells - layout saved for every tableimport/export to external files (SDF,CSV)filter capabilities (enter filter like (price>3.14)sort order capabilities (enter manually the sort field(s))editing in placeimproved table generator assistantimproved field editingQueriesdefine , edit and stores "user defined queries"store queries as viewsexecution of queriesviewing of select type queries resultquery deleting and renamingVisual query builder with drag & drop capabilities. For any of you who had installed the Tcl/Tk plugin for Netscape Navigator, you can see it at work clicking hereSequencesdefines sequences, delete them and inspect them Functionsdefine, inspect and delete functions in SQL languageFuture implementation will havetable design (add new fields, renaming, etc.)function definitionreport generatorbasic scriptingIf you have any comment, suggestion for improvements e-mail to :teo@flex.roInformation about libgtclYou will need the PostgreSQL to Tcl interface library libgtcl, lined as a Tcl/Tk 'load'-able module. The libpgtcl and the source is located in the PostgreSQL directory /src/interfaces/libpgtcl. Specifically, you will need a libpgtcl library that is 'load'-able from Tcl/Tk. This is technically different from an ordinary PostgreSQL loadable object file, because libpgtcl is a collection of object files. Under Linux, this is called libpgtcl.so. You can download from the above site a version already compiled for Linux i386 systems. Just copy libpgtcl.so into your system library director (/usr/lib). One of the solutions is to remove from the source the line containing load libpgtcl.so and to load pgaccess.tcl not with wish, but with pgwish (or wishpg) that wish that was linked with libpgtcl library. 12.2 Windows Interactive Query Tool for PostgreSQL (WISQL or MPSQL)MPSQL provides users with a graphical SQL interface to PostgresSQL. MPSQL is similar to Oracle's SQL Worksheet and Microsoft SQL Server's query tool WISQL. It has nice GUI and has history of commands. Also you can cut and paste and it has other nice features to improve your productivity.http://www.troubador.com/~keidav/index.htmlEmail: keidav@whidbey.comhttp://www.ucolick.org/~de/ in file tcl_syb/wisql.htmlhttp://www.troubador.com/~keidav/index.htmlEmail: de@ucolick.org12.3 Interactive Query Tool (ISQL) for PostgreSQL called PSQLISQL is For Character command line terminals. This is included in the distribution, and is called PSQL. Very similar to Sybase ISQL, Oracle SQLplus. At unix prompt give command 'psql' which will put you in psql> prompt. Type \h to see help of commands.Very user friendly and easy to use. Can also be accessed from shell scripts. 12.4 MPMGR - A Database Management Tool for PostgresSQLMPMGR will provide a graphical management interface for PostgresSQL. You can find it athttp://www.troubador.com/~keidav/index.htmlEmail: keidav@whidbey.comhttp://www.troubador.com/~keidav/index.htmlhttp://www.ucolick.org/~de in file tcl_syb/wisql.htmlWISQL for PostgreSQL http://www.ucolick.org/~de/Tcl/picturesEmail: de@ucolick.org k

Wyszukiwarka

Podobne podstrony:
PostgreSQL HOWTO pl 12
PostgreSQL HOWTO pl 14
postgresql howto 2 sbwkypklexthirkxinadnzn5bnrnjpmv6ioukqa
postgresql howto 10 4yctbmdygvosxskplagrc3lw4rwfp7x2owdlrhq
PostgreSQL HOWTO pl 18
PostgreSQL HOWTO pl 29
postgresql howto 8 ilmokh7v3r2bkwn6gu65fe53ppany4gawhvzjcy
security howto 12 sezbwv7n6y47gabon75tio6lcgxevwjrrm4eeta sezbwv7n6y47gabon75tio6lcgxevwjrrm4eeta
PostgreSQL HOWTO pl 5
PostgreSQL HOWTO pl 7
postgresql howto 14 kn2w7fwcayns6hofky7vrmybbvkoougqy7mlcty
printing howto 12 iizcwkqa3ivaohfbc676kdj6r7jr73yhxcmopci
nis howto 12 477ykmyefaabz7pjxngagtibkkicjlh7k6hutji
postgresql howto 21 ze32s6fi74b6jidqmdrybc6ux3f3kar2e4sm7di
PostgreSQL HOWTO pl 20
keyboard and console howto 12 4jv4i6pgihwufxdzd424u24tcxbbqgebtu6f7qa
postgresql howto 19 edahq34hdqjq3x5vvtn7sp6rx2kv6frrhhwtxiq
postgresql howto 27 j3v42lwktd5h5jrrldlealmuwb36rac6miq7abi

więcej podobnych podstron