Re: [SQL] Error in restore the Database in Postgres

dipesh wrote: Dear Sir, I have Mysql database backup file ( xyz.sql ). Now i want to restore this ( xyz.sql ) file into Postgres Database. I try following command to restore but Postgres gives me the Error. You have a mysql dump, which is designed to restore to a MySQL database. It will incl

[SQL] Error in restore the Database in Postgres

Dear Sir, I have Mysql database backup file ( xyz.sql ). Now i want to restore this ( xyz.sql ) file into Postgres Database. I try following command to restore but Postgres gives me the Error. psql -d tracker -f /home/postgres/backup/tracker_db.sql In xyz.sql file Lock Table; statement is writ

Re: [SQL] error codes

Craig Ringer wrote: > Marcin Krawczyk wrote: >> Hi guys. Does anyone know the error code for '/currval of sequence * is >> not yet defined in this session/' error ? Is there one at all? > > A quick JDBC test program shows: > > ERROR: currval of sequence "customer_id_seq" is not yet defined in thi

Re: [SQL] error codes

Marcin Krawczyk wrote: > Hi guys. Does anyone know the error code for '/currval of sequence * is > not yet defined in this session/' error ? Is there one at all? A quick JDBC test program shows: ERROR: currval of sequence "customer_id_seq" is not yet defined in this session (SQLState: 55000) whi

Re: [SQL] Desc Commnad in pgsql?

VG wrote: Hello All, I like to know how can I achieve the same functionality that is give by desc commnad in mysql or oracle. http://www.postgresql.org/docs/8.3/static/app-psql.html See the \d command, e.g. "\d mytable" There are many different backslash commands that can give you details on

Re: [SQL] Desc Commnad in pgsql?

am Thu, dem 17.04.2008, um 14:17:45 +0530 mailte VG folgendes: > > > Hello All, > > I like to know how can I achieve the same functionality that is give by desc > commnad in mysql or oracle. 'desc'? descending, describe, desc... wild guess: describe, like ORA. You can use \d within psql, ple

[SQL] Desc Commnad in pgsql?

Hello All, I like to know how can I achieve the same functionality that is give by desc commnad in mysql or oracle. Also specify me the book related to pgsql as a beginner. Presently my task is going to be communication of ruby with pgsql Thanks in advanced. Vikas

[SQL] error codes

Hi guys. Does anyone know the error code for '*currval of sequence * is not yet defined in this session*' error ? Is there one at all? I am aware of *others *code but I'd like to avoid using that. Thanks in advance. Regards mk