103 reputation
114
bio website
location Slovenia
age 35
visits member for 3 years, 10 months
seen Feb 9 '11 at 7:38

May
18
awarded  Famous Question
Feb
4
awarded  Nice Question
Jul
27
awarded  Notable Question
Dec
22
awarded  Popular Question
Feb
9
awarded  Scholar
Feb
9
comment Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?
ok, i traced the pg_dump. But it wasn't as easy, becouse i had to write my own function in C# to write the create table statement. But it was a big help, so thank you veeeeerrrryyyy much. :D
Feb
9
accepted Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?
Feb
6
awarded  Student
Feb
6
comment Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?
@SvenW: I would do that if i'd have a known set of tables. The problem is that the user can, if he chooses to, sync any table in selected database and then create the selected table on a remote server behind a wcf service. I can do that with mssql and now i want to expand the client program to other sql servers (mysql, oracle, postgresql, ...) OK, I can do pg_dump for a table that the user wants to sync, but if it is at all possible to do that just in plsql, i want to do it in plsql
Feb
6
comment Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?
i'll try to explain the problem in more detail. I need the sql statement (select or stored procedure) becouse I execute the sql command in C# (NpgsqlCommand). So I think the pg_dump is not the solution in this case. :(
Feb
6
asked Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?