Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ConradIrwin

    Functions and Transactions , need workaround

    Could you reimplement your batch files as internal functions? Thus calling one complicated function with arguments that returns the final results - do a google for "postgresql C function
  2. ConradIrwin

    shp2pgsql Help with syntax!

    To create a new database or schema you can issue the commands "CREATE DATABASE foo;" and "CREATE SCHEMA bar;", though I always find it easier to work in the "public" schema. If you want to use the database, you need to start the connection with the database name as a parameter (i.e. "psql foo")...
  3. ConradIrwin

    Create table with comment

    As far as I know this is not possible, there is no field in the table "pg_catalog"."pg_tables" that would seem to allow having a comment.
  4. ConradIrwin

    Query Optimisation

    Hi, I am storing the text for certain sections in my site in a multilingual, multi-revisional table (site_text) And, in order to render a page I need to extract all the relevant information from there by referencing the keys from (site_page). I have the following query, but I am worried about...

Part and Inventory Search

Back
Top