View Full Version : postgresql answers


Pages : 1 [2] 3 4 5 6 7 8 9 10 11

  1. Function returning uple?
  2. How to get password once from user and use that in entire MSDOS batch file.
  3. in postgres sql
  4. when restoring the dump in postgresql 7.3.4, no functions are available
  5. How to enable PITR on all POSTGRES server
  6. Batch file + psql problem
  7. getting started with v 7.4
  8. how to append the string to SQL queries in stored procedure of Postgres....
  9. Creation and modification timestamp
  10. to change datatype
  11. Problem in converting float4 type to float8
  12. postgreSQl chennai trainingc enter
  13. returning columns from different tables, in plpgsql function
  14. Names of columns with foreign keys
  15. Error: relation with OID 22938 does not exist
  16. how to qeuey this in paadmin like mssql
  17. Can you use a stored procedure in a subquery in postgres?
  18. Installation fails
  19. Encoding problem in create database
  20. Address already in Use, postgres doesnot restart
  21. Restoring the dump in a new database does not contain oids
  22. Selection in pgsql using dynamic tables.
  23. Table Creation Problem
  24. Connecting to PostgreSQL using VB.NET
  25. BYTEA convertion to TEXT
  26. PostgreSQL Tablespace Creation Problem
  27. doubt in CASE command
  28. Can I connect to remote DB using psql?
  29. Installation Problems with Windows XP
  30. return type of function wen having different datatypes
  31. round to the nearest integer
  32. Is there a PHP cursor?
  33. Bitemporal tables sequenced unique triggers
  34. postgresql
  35. syntax to view the structure of a table using sql
  36. Running ACT! 2008 Database on two Laptops
  37. getting tuples of result
  38. how to configure Pgpool-II to replicate postgres database in linux
  39. Restore from plain text
  40. Problem in executing sql file
  41. trigger problem
  42. double quotes inside single quotes => ' " ... " '
  43. How to show time stamp in postgres pg_log/TodaysFile
  44. plperl problem
  45. How to setup a Arabic compatable Postgres DB
  46. postgreSQL user permission denied
  47. Postgresql database connection error...
  48. doubt in update query inside a function
  49. CREATE LANGUAGE cannot load library
  50. Need help with a slow UPDATE query
  51. PostgreSQL logical storage
  52. pg_restore in C - language how to...
  53. Physical files
  54. Problem in Select Query
  55. PostgresSQL server connectiong problem with C-language...
  56. Transactions
  57. converting POINT(-43.16 -0.876) to Latitude and Longitude
  58. doubt in exporting a file into database
  59. datamodel
  60. executing a query daily
  61. Error in following query
  62. PG archiver problem
  63. PostgreSQL dump restore from client
  64. Online replication of Postgresql databases
  65. Performance Tuning
  66. Postgresql Reinstallation problem on Windows
  67. problem in using unicode datatype
  68. current transaction is aborted. queries ignored until end of the transaction block
  69. Problem regarding a function
  70. install postgre
  71. install postgre
  72. why did not suppert Rollback? postgresql
  73. doubts in slony
  74. difference
  75. PostScript Reports
  76. stupid misstake with DB encoding
  77. Query about 20,000 record problem(slow)
  78. Problems with unique key constraint.(CASE INSENSITIVE)
  79. Insert data in win1251 encoding to base with utf8 encoding
  80. Problem inserting into a view
  81. Updating a coloumn value by comparing coloumns from two tables
  82. Top Value in a Table
  83. PostgreSQL equivalent to MySQL LOCATE()
  84. pg_dump backup doesnt restore everything - things missing... restore howto required
  85. Using the result of a function that RETURNS SETOF
  86. Closing a database
  87. doubt regarding rollback
  88. database connection problem
  89. logically-delete a row rather than actually remove in from table in postgreSQL
  90. Restore after server crash
  91. Add not null column in a table
  92. Rules in Postgresql
  93. FATAL: role "root" does not exist
  94. postres triggers
  95. Problem: Retrieving Records based on the From & To Date
  96. doubt in arrays used in function
  97. PostgreSql Documents
  98. how to move the data ,because of the partition table
  99. doubt in function
  100. MySQL and PostgreSQL
  101. Reading into FoxPro via psqlODBC
  102. how can we use partition table ?
  103. Combining two fields data into one field in the same table
  104. Need Help In Postgres
  105. COPY Query fails in postgre release 8.2
  106. how can i use the initdb?
  107. Optimal architecture for a postgres DB?
  108. Open Source Application Server (PostgreSQL Perspective)
  109. function in postgreSql
  110. How to speed up a query
  111. Cannot change column data type
  112. query the results of a table function applied to all the rows of a different table
  113. Project On Postgresql
  114. Duplicate a DB
  115. how to retrieve number of fields in the table
  116. Installation Issues
  117. Lock Problem
  118. How to create Function for executing query ....
  119. DISTINCT or GROUP BY don't seem to help
  120. Multiple Group by
  121. ERROR : relation "master"
  122. Error while running createdb from a batch file in windows xp
  123. Are queries different between sql and postgresql?
  124. Integer array in where clause
  125. copy command
  126. Partitioning database in Postgres
  127. how to get column names of a table
  128. copy command
  129. Using cursor for update
  130. Enterprise Wide Deployment
  131. syntax for copy command
  132. Benchmarking tools for PostgreSQL on Linux (fedora)
  133. ERROR: return type mismatch in function returning tuple
  134. ERROR: SELECT query has no destination for result data;
  135. inserting data in time field
  136. Get the generated value of serial type field (primary key)
  137. Slony-I questions
  138. Select For Update
  139. Function To Return Insert Statements In Postgres
  140. Extract date from timestamp
  141. Exporting data from postgresql to oracle
  142. Is there separate package for client and server in postgresql
  143. Server - Client Application
  144. doubt in a datatype
  145. syntax to view the structure of a table
  146. Is Pg replication used for multi master or two master asynnchronus replication
  147. explain
  148. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  149. Cant view table description
  150. PGCluster-II version 1.3 implementation
  151. Error:: 'more' is not recognized as an internal or external command
  152. What replication are people using
  153. Import data into Postgresql
  154. how to post to the forum
  155. Understanding End of Cursor?
  156. A far cry - but here's hoping - PostgreSQL Replicator
  157. Too many clients already
  158. Installation of PostgreSQL on Windows XP
  159. Help with Tags database design.
  160. retrieve two tables in a single query
  161. Returning SETOF in plpgsql
  162. oid problem
  163. How to add a column to the table
  164. Convert data from char type to byte tape
  165. Stored functions
  166. Mapping select results through a function
  167. Stored functions books
  168. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  169. alias name inside the function
  170. What is the output statement in PostgreSQL
  171. Regarding Installation of postgresql as a client - server
  172. syntax error at or near "TYPE"
  173. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  174. Hybrid Environment
  175. Too Many Client Connections -- Error -- Need Help
  176. Hello everyone, I am new to this site and SQL server
  177. Building an aggregate function
  178. "is not scalar Variable" Error
  179. scripts for converting dbf or mdb files to postgres
  180. array parameter in plpgsql function
  181. Keeping two db's in synch across continents
  182. order by for varchar datatype column with numeric values
  183. Functiion Problem
  184. starting psql in windows
  185. Postgres backup and restore
  186. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  187. shp2pgsql Help with syntax
  188. pg_restore is not recognizing dump
  189. maximum function
  190. What is commit_delay & commit_siblings?
  191. Problem with function
  192. Start of Year
  193. migration tool
  194. All About - PostgreSql
  195. PostgreSQL and OleDb
  196. Need help with triggers
  197. using ILIKE xyz where xyz is a function parameter
  198. Pgsql 8.4 on Vista starts and stops automatically.
  199. bulk copy from flat file to postgres dbserver
  200. output parameters in functions
  201. Postgres 7.x and Legato backup
  202. Postgres8.1 Database Server could not be started
  203. How to store binary files in the PostgreSql database table?
  204. How PostgreSQL searching Queries?
  205. Constraints vs Indexes
  206. Create function question...
  207. Transaction Problem
  208. Improving date(timestamp) searches
  209. crystal report
  210. How to set TG_ARGV values
  211. USE OF VARIABLES IN postgreSQL
  212. How to replace characters in dblink
  213. getting latest filled row
  214. problem with date
  215. How to get column name
  216. Auto mail sending using postgresql
  217. syntax is not supported error
  218. need an sql query for the following situation
  219. Copy Table to other database
  220. Cannot compile plpgsql function
  221. pg_dump Failure
  222. Aggregate/concatenate function (flattening columns into a row)
  223. Temporary tables
  224. User and Role
  225. How to copy data from one table to other table
  226. Function declaration for MSFTSql developer
  227. function execution
  228. using array data type
  229. What would my SQL statement look like?
  230. Database connection problem
  231. Error Installing PostgreSQL 8.1.9 on XP
  232. no lock
  233. unsorted column
  234. how to convert a query from SQL to HQL(hibernate Query Language)
  235. Beginning with PostgreSQL
  236. How to configure static ip PostgresSQL 8.1 for windows XP system
  237. How to find out that SSL is activated
  238. Postgresql 8.2 connection problem on static ip
  239. Stored Procedures in PostgreSQL
  240. execute funtions in psql
  241. SUM with possible NULL values
  242. Connecting to PostgreSQL through SSH (putty)
  243. Exporting tables from Postgres to SQL
  244. Installation of PostgreSQL 8.0 on Solaris10
  245. Stored procedure
  246. problem in querry
  247. Adding new column to existing table
  248. Support for ROWNUM and ROWID
  249. Size of table and size of database
  250. Use Of Dblink
  251. how to export postgresql tables
  252. psql won't connect, though other clients are OK
  253. Serverless/embedded PostgreSQL database
  254. Date difference
  255. count months between two dates
  256. 24 hour time format
  257. Substract hour into a function
  258. import Excel to postgreSQL
  259. Retrieve number of rows in table
  260. Invoking psql at command prompt
  261. Migration from SQL Server to PostgreSQL
  262. How to recover the deleted fields with values from bakup.
  263. recovering fields in tables
  264. Postgres Violates Primary key and OID
  265. hai i am new here.i have question,please give me reply as soon as possible
  266. Function returning setof
  267. PostreSql function
  268. Migrating IBM Universe Database to Postgres, date format Problem
  269. Run Unix Shell Scripts With Postgres Trigger
  270. server closed the connection unexpectedly
  271. getting current date
  272. For Report Generate
  273. Usisng PQgetvalue
  274. Database Design Help
  275. Need help with query involving automatically decaying values
  276. psql copy
  277. Getting Parse Error at or near and at character......
  278. Variable column name
  279. Transfer of Data from Oracle to PostgreSQL
  280. create database if not exists
  281. data fetch and insert
  282. Oid
  283. Foreign key problem
  284. How to assign a primary key
  285. pg_restore doesn't work for postgresql 7.2.3
  286. How To Execue Queris Fastly
  287. Posting Guidelines. Please read before you post in a forum!
  288. Inheritance Problem
  289. Help : what this Error means
  290. Installing PostgreSQL 8.1 on VISTA
  291. load balancing
  292. how retrive this problem
  293. Problem in function with CREATE ROLE with parameters
  294. BackUp and Restore PostGreSQL8.1
  295. HOW TO exit from a query
  296. controlling postgres I/O and CPU processing
  297. performance tuning postgres 8.2.3 on windows with shared server applications
  298. Retrieving values from tables
  299. stored procedure in postgresql
  300. Problem with Windows PostgreSQL 8.1 service
  301. download old version of PG
  302. restore problem
  303. how to compare two tables
  304. what is the keyWord DELETING
  305. Strange result using transactions
  306. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  307. Postgresql installation problem??
  308. php objects in postgresql
  309. odbc call failed
  310. Starting More Than one Transaction
  311. Fatal error: Call to undefined function pg_connect()
  312. Connection Exception
  313. joins
  314. How to know the Number of Connection made with the database
  315. how to write the select query for this situation
  316. C# .NET ===> postgreSQL
  317. Pagination in Postgre
  318. If criteria is Null then show all.
  319. Test Suite for Postgresql
  320. How can I display the stored image?
  321. Storing files in Postgresql database
  322. Interface to posgresql
  323. How to check a query execution plans in PostgreSQL
  324. HOW TO merge two strings
  325. need copy table sql example in postgres
  326. use of client-side \lo_import and \lo_export commands
  327. Server doesn't listen
  328. SHA function?
  329. Fastly Inserting Records
  330. how to release locks when instance crashes
  331. HOW TO Use transaction control statements inside a sored procedure
  332. Back Up And Restore
  333. Functions and Commits
  334. how to write this sql statement
  335. Nested use of found doesn't seem to be working
  336. Alter table doubt
  337. Driver for postgresql
  338. Redundant data in postgres
  339. Migrating data between dbs with different schemas
  340. Postgres Newbie - Case Problems in queries
  341. Multi dimensional arrays, sub selects...
  342. Error When creating the table
  343. String was not recognized as a Valid Date Time
  344. Postmaster is accepting TCP/IP connections error
  345. Data Migration From Excel to PostgreSQL
  346. date queries with portions of the date unknown
  347. How to Fix Corrupt Tables
  348. Unable to connect
  349. Postgresql Compression Across Network
  350. limit database size
  351. limit database size
  352. query and subquery in python
  353. retrieve column array values
  354. how to execute script from file within function
  355. retreive values from an array into column
  356. Can PostgreSQL initiate a message through a socket?
  357. how to insert image
  358. which is the best interface for postgresql
  359. unable to set 'Owner' column to different role
  360. username
  361. inserting values into array column
  362. Query regarding odbc connection ??
  363. how to give login in a table
  364. limitation of postgresql
  365. how can I fetch data from the database and display it in form of a editable html form
  366. ALIAS error
  367. postgis function
  368. FATAL ERROR on Solaris 10
  369. postgresql function
  370. invert an array
  371. postgresql installation fails on windows 2000
  372. accessing last element of an array
  373. How to cast varchar into timestamp in postgres
  374. How to make a copy of data in RAM ???
  375. update multiple cols in trigger
  376. How to make cross-database reference in Postgres
  377. nesting joins
  378. How to insert multiple sub columns inside a column ??
  379. on delete set null problem
  380. Databinding bool fields
  381. Increase the Cache Size
  382. Query regarding SQL commands ?
  383. how to make a Postgre DB setup on windows
  384. PL/PGSQL function
  385. getting the last record using timestamp
  386. create database test if not exists
  387. Writing DDLs in Functions
  388. Writing DDLs in Functions
  389. Postgre Sql on Solaris operating system
  390. urgent help!!
  391. Sum of “sales” for each date in a timestamp column
  392. How to know that a schema exist?
  393. Web Development Team Needed - Prefer Croatian or Eastern Europeanbased
  394. PHP Postgresql "All-In-One" CRUD Needed
  395. need help
  396. a problem when I create a trigger procedure.
  397. Postgres on XP / ODBC setup / Visual C++ API
  398. Transaction Logging Mechanism
  399. SQL question??
  400. TCP/IP Connection Error
  401. The MySQL command LEFT() counterpart in PostgreSQL?
  402. Exception Handling
  403. current transaction aborted
  404. SQL problem, help if possible please.
  405. How can I support multimedia with postgres?
  406. Postgres Connection Error
  407. HI all
  408. Restoring dump files completely
  409. PostgreSQL - JDBC2 lose connectivity after a while
  410. hi all
  411. .NET Questions
  412. postgresql module
  413. Copy / Paste in PostgreSQL from remote server.
  414. postgresql installation
  415. functions in postgresql!!!
  416. select distinct with datatype point
  417. an urgent question
  418. data conversion
  419. select-where anomaly
  420. Migration od Database
  421. installation error
  422. inserting values in relational main tables
  423. Hash index creation problem
  424. How can we manage PK and FK using inheritance??
  425. Are Primary Keys Necessary for Linking Tables?
  426. filename extension postgreSQL
  427. DBF to Postgres using DBF2PG
  428. Bulk Extract and Load data in PostgreSQL
  429. error in logs file
  430. To insert 60million rows to database
  431. can't get the full results from postgresql
  432. What is ODBC Query timeout error
  433. How to configure postgres for max disk space usage
  434. web interface library/classes
  435. Sql Case Statement
  436. Problem with executing Postgres function from javacode
  437. pg_clog errors
  438. table creation
  439. Postgres and ESQL
  440. Postgresql Vs. Mysql -- Need advice
  441. How to write postgres query with time comparison ?
  442. Hey i need advice!
  443. Subjectre31
  444. Reg Postgres Sql Replication Concept
  445. Reg Postgres Sql Database Instal On Windows 2000
  446. Syntax error doesn't make sense...
  447. just some info you might be intersted
  448. Tickets
  449. Create UNIQUE KEY
  450. Reg AutoVacuum
  451. Garbage Collection with Custom Session Handlers?
  452. Performance problem with joins
  453. plpgsql FOUND unexpected behaviour
  454. Need Clarification About Replication Concept In Postgres Sql
  455. How to convert from sql to postgresql (stored procedure)
  456. 7.4.13 LANG=C, order by still wrong
  457. Recieving notification when a table changes
  458. Limitation in query result from postgresql table
  459. date format in postgresql database
  460. libpqdll.lib
  461. Help with Database Solution
  462. Linking Tables from 2 databases
  463. Ora2PG exporter and UTF Characters
  464. alternative to distinct on?
  465. How to Use "If Exists" in PgSql
  466. Postgresql Stored procedures
  467. Postgresql
  468. Money datatype?
  469. Performance Issues PostgreSQL on Solaris
  470. Two general, simple questions
  471. Postmaster Problem
  472. What architecture for a Large Database with PostgreSQL
  473. XP Embedded and Postgres No Happy Campers
  474. Fedora Core 4 & PostgreSQL
  475. xml export tool?
  476. Dual servers
  477. Python x Postgresql Thrreading Problem
  478. Outer Join on 3 tables
  479. Conditional delete
  480. Timestamp not working
  481. is there a function which elminates spaces?
  482. OLAPy stuff crawling a bit
  483. async queries (libpq)
  484. Looks to me like MySQL has a change coming
  485. Generate/Manage a PostgresSQL database using Visio?
  486. PostgreSQL Linked server question with MSSQL2K
  487. Urgent: Input of values to execute dynamic queries
  488. 1991 and 1992 Black Box Catalogs
  489. Happy Fish Database Designer
  490. Need Database person
  491. Need Database person
  492. encoding question
  493. Where can I download HTML manual?
  494. linking access using ODBC driver with geometric data
  495. Good Portal for data mining resources
  496. Tablespace layout question
  497. scroll cursor bug or me?
  498. SQL Profiler
  499. How to copy a PG database
  500. ordering text field with non-alphanumerical character
  501. crosstab error 'query-specified return row and actual function return do not...
  502. Statement-level Triggers
  503. DateAdd function ?
  504. views, functions and parameters...
  505. ADO and PostgreSQL functions
  506. How to return a record and sets of record in plpython
  507. Great News Blog!
  508. Query Optimizer Failure / Possible Bug
  509. Bitwise operators for bytea
  510. can't update bytea field with function
  511. resultset to xml
  512. Tsearch index not set by UPDATE in PgSQL 7.3.2
  513. function no return
  514. Installing PostgreSQL 8 on Debian
  515. how to run function?
  516. SQLDescribecol in driver 8.00.0100
  517. Postgresql 8.0-beta2-dev3 on Windows 2000
  518. Adding pgAdminIII Server - Passwords?
  519. Good page with Oracle x PostgreSQL comparsion
  520. PostgreSQL and XML
  521. Danish users
  522. simple query runs very slowly
  523. using OLD variable in DELETE trigger
  524. Please Help with libpq and unicode
  525. eval function?
  526. Postgres+XML
  527. SQL Query
  528. libpq location?
  529. pgsql user account in pgadmin doesn't need password
  530. SuSE Linux and PostgreSQL
  531. What is future of partitioning?
  532. PostgreSQL/PHP/UTF-8?
  533. Oid Type
  534. The second RFD is in news.groups.
  535. Table name as parameter in function
  536. Upcoming Changes to News Server ...
  537. I need to add a column to a table
  538. Will B4->B5 require an Initdb?
  539. Lexical question...
  540. Bug in queries ??
  541. PostgreSQL 8.0.0 Beta 5 Now Available
  542. null value of type java.sql.Time
  543. primary key and the default index operator class
  544. Postgres-Windows -Perl DBI
  545. Foriegn Keys?
  546. SELECT duplicates in a table
  547. Storing every scrabble board possible
  548. Help with syntax for timestamp addition
  549. null value of type java.sql.Time
  550. Oid to text...